Regex not working

Help Studio
, ,
1

Hello All,

I want to get the regex of reference value witch

Reference APZU4709586
Reference APZU4709585
Reference APZU4709587

it can be with three occurence ,sometimes it is empty, and in (second occurence
the Reference text does not exist (like this)
Reference APZU4709586

Reference APZU4709587
How manage the both situation please

Best regads

2

Hi,

Hope the following helps you.

image
image1340×655 43.2 KB 

"(?<=Reference\s+)\w+"

Sample20220612-1.zip (2.4 KB)

Regards,

1 Like
3

Hi @nora_ziani I have updated a Xaml file below which will help you to extract the reference values. Irrespective of the input the regex code i have written will help you to extract the reference value.
RegexDateExtraction (1).xaml (5.4 KB)

4

Hello
Thank you , but the problem i have other Reference , then I changed it into this ,
(?<=Reference)(\w+)(\d+)
I want to get the first occurence , second , third separately

5

Hi,

Sorry,I didn’t realize your reply. I replied for this the following topic.

Regards,

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.