Hi All,
I want to do something quite simple but I'm struggling. I have a long text string with SOH (Start of Heading) characters in it. I want to replace this with a '|' character. Any tips?
Best Regards,
Dan
Solved! Go to Solution.
I think this formula should do the trick
Replace([Field1], CharFromInt(1), "|")