Regex for searching and extracting strings

Hello,

Hope someone can help. I’m new to regex so I don’t quite understand it yet but if you could guide me how to use it for this case, that would be great.

image

I have this description and I need to extract everything that is including “NC-” and the five numbers after it. Example, “NC-XXXXX”

Would that be easy? Thanks!

Hello @Ana914,

this should work in String Manipulation node:
regexReplace( $yourColumnName$, ".*(nc-\\d{5}).*" , "$1" )

You can test this and get explanations here:

Br,
Ivan

5 Likes

Thank you, @ipazin !! Very quick reply, and it works and thanks for the link as well. It will help me understand it :slight_smile:

1 Like

This website is amazing!!!

1 Like

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