Split Date From String

[LwinMoeAUNG]

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

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

[HareeshMR (Hareesh Madasi)]

Assume Str is the variable…

temp = str.split(cchar(“(”)).Last
date = str.split(cchar(“)”)).First

[lakshman (Ganta lakshman)]

@LwinMoeAUNG

Try below one:

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

str.split(“(”.tocharArray)(1).Replace(“)”,“”)

[Lahiru.Fernando]

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)

[Jan_Brian_Despi]

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

Thank you!

[LwinMoeAUNG]

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