How to convert the last character into date format

Hi,

I want extract the last numbers from the below string and want to convert it into date format(DD.MM.YY) and replace the already existing last numbers to the converted date format.

COR_2020_FBIG_OnlyHumanPastureVersion1_Video_:30_2074760_Human Energy_43874.20

@Palaniyappan

1 Like

@monish06
have a look here:
grafik

extracting the number form string we can do with

Hope this helps! Let me know if you need help with the splitting of the string based on underscore, I can help you add that part in. Cheers!

@monish06

Check as below

Tutorial : Convert Number to Date Format

Hope this helps you

Follow Link

Thanks

Adding on the regex for identifying the last part. However, for some reason when I use this regex expression inside a “matches” activity and pass in the same string as an input variable, I am getting 0 matches returned. I’m not sure why this is, and for this we might need someone with more expertise to comment. Tagging @Palaniyappan to help :slight_smile:

1 Like

After converting i would like to replace with the date format?

@monish06
not sure if I got you. Maybe you are looking for this:
monish06.xaml (6.1 KB)

No actually i did the conversion, now i want to replace the converted date at the end of the string.

@monish06
have a look here:
monish06V2.xaml (7.4 KB)

or as an alternate: strText.Replace(strODate, strDate)

2 Likes

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