I'm hoping this is easy.
I need to create a text delimited file that uses an asterisk as the delimiter.
To start, I unioned two files with the column name file being input 1.
I need to populate the delimiter column with the Asterisk but it keeps turning the " * " into a zero.
Solved! Go to Solution.
Hi @Number4
This should be as simple as getting your data how you want it, and then using an output tool to create a csv file specifying * as the delimiter. I did a quick test and it seems to be working.
How are you currently populating the delimiter?
I had created multiple delimiter columns (adding 1, 2, 3 etc. to the name.)
I'll remove them and just use the option you'd shown.
I knew there had to be something simple I was overlooking.