Removing " � " from the text using ui path

Hello Guys ! I would like to ask your help regarding the issue of text file where I am encountering the “�” in my text file and I want to remove it using ui path.

@aditya.bhandwalkar

Check as below

Thanks

Hi @aditya.bhandwalkar

Please try this,

  1. Read the text file using read text file activity, give the filepath and store the output in a variable (strText)

  2. Use write text file activity, provide the same text filepath and pass the string as

strText.replace( “�”,"")

Thanks

1 Like

Hi @aditya.bhandwalkar

Please use below code,

image

image

Thank you

when yo do face such characters, then an adoption of the used character encodings is recommended

1 Like

Thank you!

1 Like

Hi,

If possible, can you share your text file as a file?
As @ppr mentioned, in many cases, it’s caused by settings of in-proper encoding type.

The following is example of this case. (Read CP932 text file as UTF-8)

Regards,

1 Like

Thanks!

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