Removing " � " from the text using ui path

[aditya.bhandwalkar]

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.

[Srini84 (Srinivas)]

@aditya.bhandwalkar

�

@aditya.bhandwalkar

Check as below

Thanks

[prasath_S]

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

[Jobin_Joy]

Hi @aditya.bhandwalkar

Please use below code,

Thank you

[ppr (Peter Preuss)]

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

[aditya.bhandwalkar]

Thank you!

[Yoichi]

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,

[aditya.bhandwalkar]

Thanks!