Insert an * as text

[Number4]

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.

[Luke_C · Accepted 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?

[Number4]

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.