How to convert the last character into date format

[monish06 (monish)]

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

[ppr (Peter Preuss)]

@monish06
have a look here:

extracting the number form string we can do with

• regex
• string functions
  e.g.:
  
  

[himavad (HimG)]

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!

[Srini84 (Srinivas)]

@monish06

Check as below

Tutorial : Convert Number to Date Format - #2 by system

Hope this helps you

Follow Link

Thanks

[himavad (HimG)]

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

[monish06 (monish)]

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

[ppr (Peter Preuss)]

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

[monish06 (monish)]

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

[ppr (Peter Preuss)]

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

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