Parse Using Regex

[omarammar95]

I want to split into 2 columns where I have index price in a column and the number in another column also same for datetime should be in a column and datetime in another column, you will find attached picture of the workflow and the file itself, I should mention that I extracted this data from HTML link so any HELP !!!

[ShankerV]

Hi @omarammar95 

Please find the expected output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @omarammar95 

Adding the formula tool, will help to remove the last special character too.

"([a-zA-Z]+)":"{0,1}(.+)

Note: I cant use the download tool here, hence shared the result from the screenshot shared from your end.

Hope it helps!!!

Many thanks

Shanker V

[davidskaife · Accepted solution]

Hi @omarammar95 

You don't need to use Regex if you don't need to: the data has a : as a data split, so you can use Text to Columns on that and tidy up the outputs using Trim function:

Workflow attached to help you

[omarammar95]

Thanks guys for your help both ways worked, really appreciate it