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.....
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 “ “.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.