REGEX Issue to extract data from a string

[paul.genoud]

Hi everyone,

Here is my use case.
I’m scanning barcodes with the data “A0000015665279” inside it.
I want to extract from this code only the part “15665279”.

I tried to use the following REGEX to do this : /[A-Z]0*(\d+)/

I tried to use the REGEX_MATCH function in TULIP :

But I don’t have any outputs in my variable.

Any advice on what I’m doing wrong ?

Thanks,
Paul

[ta-aoki]

I do not know if this is expected behavior, but it seems like you should either try these

• ‘[A-Z]0*([1-9]+)’
• ‘[A-Z]0*(\d+)’

It worked in my sandbox(r303.1)

[ta-aoki]

OK, this community post also seem to escape \ .
You should either try

• ‘[A-Z]0*([1-9]+)’
• ‘[A-Z]0*(\\d+)’

Please note that you need two ‘\’ before ‘d’

[ta-aoki]

Maybe you would like to vote for this Product Suggestion!

Add Unique Coloring for Escape Character Backslash

An item which is not super obvious when using expressions is that the “\” character is actually an escape character. This is standard with strings, but for users who aren’t familiar with that convention it is not intuitive. This mainly shows up with Regular expressions, since all backslashes in the expression have to be doubled for the expression to run correctly. For example, see below: [image] It would be nice to have escape backslashes given a different color compared to normal text, to ma…

[paul.genoud]

Hi @ta-aoki, thank you for the inputs ! The REGEX you sent are working perfectly