Help needed for trim of stings

Cristine014

New Member
How can we remove the spaces of the strings if it has hidden spaces/characters. Trim function seems not working. Please help.
 

Manikanta

Member
How can we remove the spaces of the strings if it has hidden spaces/characters. Trim function seems not working. Please help.
Hey @Cristine014
Let's take a ''Calculator and make a clear option by pacing-- " " --'' B4 splitting ur string, For clearing those outputs are from the split string output, need to map in clear for every new file u want to clear.
This try once to get remove spaces and extra strings which u don't need in ur target App.....
 

Cristine014

New Member
Thank you for responding. Though that is not working as well since the extra spaces i wanted to remove has hidden characters that we cant see. But i was able to find a solution by using CHR 168 instead of “ “.
 

Cristine014

New Member
So what i did is replace([data1],(chr168), “”) since i am unsure what is the hidden characters in the text. And it works fine. Thank you again for responding. :)
 
Top