RegEx Order IDs

[DelData]

Hi there....

i have an example of messy data where i need to be able to extract the Order IDs from the Order ID Column

The Order ID columns have other data info in them so i looking for clean way to use regex to extract the order ids for each row

Sometimes there will be more than one order id for each row.....eg row 1 has 2 order ids and row 2 has 3 order ids..etc..

Can you help?

 

[alexnajm]

You should be able to use the Tokenize option (Split to Rows) in the RegEx tool to split to an unknown amount of order IDs in each record

[DelData]

could you update the workflow attached to show me....its the regex expression i need help with

[alexnajm]

I did - but RegEx is something I would consider learning since it is a very useful language for parsing!

[DelData]

Great thanks......the formatting of the order id column may change....

What I really would like is a way to use Regex to search the the word Order ID(s) in column B for each row and the return the whole line e.g....what i want is shown in Column C.....would you be able to update Regex to do that?😀

 

[alexnajm · Accepted solution]

Yes you can do that - \|Order ID\(s\)[^\n]+\n would be the regex and you can split to one column instead

[DelData]

Perfect.....that worked.....thanks for your help.......RegEx is very help and i need to practice 👍

[alexnajm]

Agreed - practice makes perfect!