extracting and converting date

[srk0609]

Hi,

can anyone please help me extract and convert this data. I'm attaching input file in xlsx format and photo desired output. I would like to have 3 outputs like this in V_String or VW_String data type. Thank you.

[Emmanuel_G]

Hi @srk0609,

You can find a test attached with the exact desired output.

Let us know if it works as you want.

Cheers,

[srk0609]

Thank you so much, Philip for your help. I just need one more small help from the same INPUT file, could you help me extract this?

[PhilipMannering]

Hi @srk0609 You can just use the Text to Columns tool and split on a space to get that! Let me know if you run into any difficulties and @IraWatt will help you out.

[IraWatt]

Hey @srk0609,

Exactly, for that all you need is the text to columns tool and put a space as the delimiter, see below:

HTH,

Ira