Using Regular Expression - Parse

[Jennyman130]

Hello all

My regular expression (\s+)$ to split out the timezone SST (eg.11/16/2017 5:24PM SST) doesn't work, the cells turn out blank. Would you have an idea what went wrong with it please?

Many thanks!

[ponraj]

You can use regex [^\s]+ with output method Tokenize to split the timezone. 

[bharti_dalal · Accepted solution]

Hi @Jennyman130,

I am attaching the solved workflow. I have done it both with regex and text to column tool. Hope it hepls.

[Jennyman130]

Thanks a lot both, it works! And I have one more question on how to use the datetime tool to convert 11/17/2017 4:42 PM to date timestamp (24Hrs format) so I can convert it to a local time where we re based. A sample workflow will be appreciated.

[bharti_dalal]

Hi @Jennyman130,

I am attaching the solved workflow. I hope it helps.. Get back for any queries.

[bharti_dalal · Accepted solution]

Hi,

Here is workflow for 11.0 version.

[Jennyman130]

Thanks it worked perfectly! Thanks a lot Bharti! You re brilliant!