Regex for searching and extracting strings

[Ana914]

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.

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!

[ipazin]

Hello @Ana914,

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

You can test this and get explanations here:

regex101: build, test, and debug regex

Br,
Ivan

[Ana914]

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

[Ana914]

This website is amazing!!!