question

sakuraime avatar image
0 Votes"
sakuraime asked sakuraime commented

Azure Datafactory data flow regexmatch for digit

Not sure what's the issue , I am going to use conditional split to find rows match something like .* 12345.23
using the following expression regexmatch , but seems can't help me to identify the rows.

99698-image.png


azure-data-factory
image.png (86.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MarkKromer-2402 avatar image
0 Votes"
MarkKromer-2402 answered sakuraime commented

Does this work for your data? ^(\d{5}).(\d{2})$

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi. thanks . and let me try and feedback to you . thanks

0 Votes 0 ·

Hello @sakuraime,
We haven’t heard from you on the last response from Mark and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @sakuraime,
We haven’t heard from you on the last response from Mark and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·
Show more comments