Text file: change date format

Help Studio
, , ,
1

Hi,
i have a txt file with date in this format “26.04.2021”.
I need to change format to “26/04/2021”
It’s possible use Replace function with regular expression?

Thanks

2

Hi @d_liberati

String.Replace(“.”,"") will give the expected output.

image
image1247×475 24.5 KB

Regards

3

In the file i have other data, so i can’t replace “.” with “,”, but i need to use a regular expression to search date.

4

Hi @d_liberati

How about using below regex?

Regards

5

Hi @d_liberati

Try this

System.Text.RegularExpressions.Regex.Replace("20.12.2021", "(\d{2})\.(\d{2})\.(\d{4})", "$1/$2/$3")

for whole text use

System.Text.RegularExpressions.Regex.Replace(fullTextString, "(\d{2})\.(\d{2})\.(\d{4})", "$1/$2/$3")
1 Like
6

This worked for me too

1 Like
7

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