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.
Solved! Go to Solution.
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.
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 ?
Maybe try this instead:
REGEX_Replace([Field_1],"[^_-\w\(\);,\.'&\s\+\*\?\^\$\\\/\|\[\]\{\}\[\]]", '')
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.
Have you checked "Treat Read Errors as Warnings" in your Input Tool configuration?
Thanks Dexter.. Now the Import function works. But the the formula does not work.
Do you have any other option ?
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.
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