How to replace string value to date format ?some times its coming without "/"

Help Studio
1

how to replace string value to date format ?some times its coming without “/”?

image

2

grafik
grafik440×652 10 KB

grafik

Simplified:
Regex.Replace(strText, strPattern,"$1/$2")

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

1 Like
3

if date format is correct it should not change, if its wrong then it should update. will this regex avoid if string is in correct format?

4

you saw it within the regex101 as it was not matching. Feel also free to run such prototypes within the immediate panel. So you can also prototype by yourself

5

can we do without regex?

6

we would recommend Regex, but have a look here:
grafik

1 Like
7

Hello @MitheshBolla ,

Did you tried to set the format for the excel? For that particular column try to set the format as Datetime dd/MM/yyyy in the excel. I hope then whenever if you add a Date in that format it will autocorrect.

1 Like
8

Actually its a template, so i am unable to edit those. i had to manipulate it in code itself

9

for c# error is coming bro

10

was not mentioned before bro

1 Like
11

my bad. i dint mentioned

12

@MitheshBolla

Refer the below post.

13

For c# what changes i need to do bro?

14

which statement did you focused? Regex or String approach?

1 Like
15

bro this regex can i have in c#?

16

regex , as u said its best practise , i had string and string pattern, i am facing issue while replacing

17

can you try

Regex.Replace(strText,@"(\d{2})(\d{2}\/\d{4})", "$1/$2");

or

strPattern = @"(\d{2})(\d{2}\/\d{4})"
Regex.Replace(strText,strPattern, "$1/$2");
1 Like
18

thanks bro

19

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