I’m running into a challenge when outputting a delimited file created from an Excel report.
The report has hidden characters that don’t appear when I write a csv file. When I use “us-ascii” as the encoding value, in my “write csv file”, I can see some data with “?”. Is there a way to remove all non ascii fields from my entire table. I’ve seen regex examples for strings but was curious about tables. I’m already trimming the data using the trim function. Can I add to it?