Quotation marks issue

Help Studio
, ,
1

I want to add all quotation marks back in my .txt file, is there a way to do that in UiPath?

2023-04-01 10:41:32;AAAA;BBBB;CCCC;“DDDD;XXXX;FFFF;EEEE
2023-04-01 12:40:02;AAAA;BBBB;CCCC;“DDDD;XXXX;FFFF;EEEE
2023-04-03 09:11:02;AAAA;BBBB;CCCC;“DDDD;XXXX;FFFF;EEEE
2023-04-11 09:11:02;AAAA;BBBB;CCCC;“DDDD;XXXX;FFFF;EEEE

now I want to transform like this (with quotation marks):

“2023-04-01 10:41:32”;“AAAA”;“BBBB”;“CCCC”;“DDDD”;“XXXX”;“FFFF”;“EEEE”
“2023-04-01 12:40:02”;“AAAA”;“BBBB”;“CCCC”;“DDDD”;“XXXX”;“FFFF”;“EEEE”
“2023-04-03 09:11:02”;“AAAA”;“BBBB”;“CCCC”;“DDDD”;“XXXX”;“FFFF”;“EEEE”
“2023-04-11 09:11:02”;“AAAA”;“BBBB”;“CCCC”;“DDDD”;“XXXX”;“FFFF”;“EEEE”

Any help, please?

2

one of many options could be a regex replace:

grafik
grafik746×732 28.4 KB

  • read text file
  • replace text
  • write text file

strPattern = (?<=^|;)|(?=$|;)
strText = System.Text.RegularExpressions.Regex.Replace(strText, strPattern, """")

in immediate panel itt looks like (a " is escaped with a second one)
grafik

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

1 Like
3

WOW this is soooooo GENIUS!!! I forgot about the regex, thank you so much @ppr

1 Like
4

perfect, so the topic can be closed by

5

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