Could someone let me know to how get rid of unknown characters from the text file.

[vgeetanp]

For Example :

I have a text in my text file (below)  wherein while importing it into the workflow I need to view it by ignoring the unknown character. Refer Below.

 

          To 

Is it easy to do ? Thanks.

[joshbennett]

Just use a Formula tool and a Replace or REGEX_Replace expression and copy / paste that symbol as the 'pattern' parameter and replace with empty quotes.

For example:

replace([Field_1], "paste the character to be removed here", "")

That should work, but let me know if you run into any issues. 

[vgeetanp]

Thank you Dexter.. But I get the below error while using the replace formula.

I used the below formula 

But in the formula Configuration field it shows like the below

Could you help to fix it ?

[joshbennett]

Maybe try this instead:

REGEX_Replace([Field_1],"[^_-\w\(\);,\.'&\s\+\*\?\^\$\\\/\|\[\]\{\}\[\]]", '')

[vgeetanp]

I Think the issue is with the input tool itself.

Do we have any way to import the report that has the below character in it?

Please assist.

[joshbennett]

Have you checked "Treat Read Errors as Warnings" in your Input Tool configuration?

[vgeetanp]

Thanks Dexter.. Now the Import function works. But the the formula does not work.

Do you have any other option ?

[joshbennett]

Can you upload a small .txt file with some of those characters included within? If so, I can take a closer look to figure out what would work.

[vgeetanp]

Hello Dexter, I have attached the Input file and the required output format.

Could you please help me to figure out a way to get the output in the required format ?

If you  can share the Workflow it would be great. Thank you. 

[KrishnaKuchibhotla]

Hi ,

I am not sure that using Data cleansing tool will solve the problem for all the rest of the scenarios that you are experiencing, but the unknown character in the text file that you shared has been solved by using Data Cleansing tool and checking the Tabs,Line Breaks and Duplicate whitespaces.

Hope this helps. Stay Safe

Thanks

Krishna