Split Date From String

Hi guys…
How do I split to get Apr/2/2019 only from below text?

> O/S Curve (Apr/2/2019)

Assume Str is the variable…

temp = str.split(cchar("(")).Last
date = str.split(cchar(")")).First

1 Like

@LwinMoeAUNG

Try below one:

str = “O/S Curve (Apr/2/2019)”

str.split("(".tocharArray)(1).Replace(")","")

1 Like

Hi @LwinMoeAUNG

Check the blow workflow… it helps you to get only the date potion of the string

Command is: Str.Split({"(", ")"}, StringSplitOptions.None)

SplitTest.xaml (4.7 KB)

1 Like

Hi @LwinMoeAUNG
Refer to the workflow I attached.dateSplit.xaml (4.3 KB)

Thank you!

2 Likes

Thanks to all!!!
I got it:smiling_face_with_three_hearts:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.