Replace text to number

Help Activities
1

Hello,

i have the following case: my input date is “13 august 2024”,13 july 2024 etc. , i need to replace all mounts to number, like august to 8, july to 7 and etc.

What is the best approach to do that?

2

For example: 13 august 2024 to 13.08.2024 , 13 july 2024 to 13.07.2024 and etc.

3

Hi @adionisiev

Use this syntax:

Input = "13 august 2024"
Output = DateTime.ParseExact(Input,"dd MMMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

image

Hope it helps!!

4

grafik
grafik790×97 15.4 KB

we would recommend to parse it into a dateTime and reformat it as needed

5

Hi @adionisiev

Try this

This image displays a process flow where a date is assigned, modified into a custom format ("dd.MM.yyyy"), and then shown in a message box. (Captioned by AI)
This image displays a process flow where a date is assigned, modified into a custom format ("dd.MM.yyyy"), and then shown in a message box. (Captioned by AI)898×722 28.2 KB

Regards,