RegEx Order IDs

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?

Order ID Extraction.png

Order ID.yxzp

Regex

Data Investigation

Accepted answers

alexnajm

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

All comments

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

Order ID_Alex.yxzp

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?😀

Order ID Wanted.png

alexnajm

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703