Help in string conversion

Help Activities
, ,
#1

Hi all,
I need help in converting the strings. Below are the string formats.

If the string is DEC01/20, I want to convert it to 2020-12-01
If the string is OCT17/20-03, I want to remove the last -03 and convert it to 2020-10-17
If the string is MAR/19, I want to convert it to 2019-03-01

Thanks

#2

Use substring method to extract data then if condition

#3

@sandyk Can you Check the Below Workflow :
According to the input data and it’s pattern, I have used a Combination of Split and Substring to get the related day, Month and Year values .
MyDemoProcess.zip (2.3 KB)

Check the workflow with all different inputs that you would receive.
Let us know if it did not help.

#4

Sure. I will check it and let you know.
Thanks.

1 Like
#5

@sandyk
the strings are interpretated as dates.
We rate a reformatting via datetime conversions more reliable as it can detect part info issues and throws validation exceptions, if it occurs. This reliable point we do lose with string based approach.

You can do following:
grafik

ensure:
grafik

#6

String query from sandy query.zip (10.5 KB)
you can use substring method please check workflow

#7

Thanks a ton :slight_smile:

#8

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