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!
Solved! Go to Solution.
You can use regex [^\s]+ with output method Tokenize to split the timezone.
Hi @Jennyman130,
I am attaching the solved workflow. I have done it both with regex and text to column tool. Hope it hepls.
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.
Hi @Jennyman130,
I am attaching the solved workflow. I hope it helps.. Get back for any queries.