This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The key thing is that your data has to be in a single column as shown in the attached example. You can then get rid of the trailing commas with a trimright formula. This will remove trailing commas from ALL rows, unless you have another way to identify top and bottom records.
You can then use an Output Data tool, CSV format with no delimiter (\0) to write your output file.
If, however, your dataset is in multiple columns, you have to get it into a single column first for this to work.