How to separate IDs from the text

[shahnawaz_khan]

Hi,

Please help in separating the IDs in separate column from the text. attaching the sample working file on which I worked manully for better understanding where i have separated the IDs in "B" column from the "A", also highlighted in bold which we have to separate.

Text which comes after (channelMsgId":"wamid) in "A "column that needs to be separated which ends with ==

[Qiu · Accepted solution]

@shahnawaz_khan 
I think we can use RegEx as below.

[Sebastian_Chaieb2]

I like the idea with Regex as I like it a lot, however for those who are not familiar with Regex I am attaching my workflow with two solutions:

1. Looks like in Column A we have JSON format so first idea is to use "JSON Parse" tool

2. Second option is to use Formula and Replace function to convert "wamid." and "==" to Pipe "|" and the use Split to column tool and as a delimiter use that | (pipe)

 

[AlexanderVM · Accepted solution]

The solutions posted here are already amazing and mine is a little repetitive but sharing anyway.