How separate channel ID

[shahnawaz_khan]

Hi,

Please help in separating the IDs in separate column from the text. attaching the sample working file on which I worked manually 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 starts (channelMsgId) like below, in "A "column that needs to be separated which ends with ==

channelMsgId":"wamid.HBgMOTE5NjUyMDQyNTU1FQIAERgSQjUxQ0YzMEU0OEZERjVEOTI0AA

[Qiu · Accepted solution]

@shahnawaz_khan 
I use the RegEx as below.

[binuacs]

@shahnawaz_khan you can also use the json parse tool to parse your text and extract the fields you want