Hex as a delimiter?

[keith-barber]

Hello,

Is it possible to use the Input Tool to define a 'light shade' character a delimited file?  Here is the character:

░

The forum won't let me upload a csv example.

Thanks,

-Keith

[JaeLim]

Hi Keith, not too sure if I understood your question correctly, but I've tried using a text input tool to test if ░ can be recognized and be used as a delimiter, looks like it works.

[keith-barber]

Hi JaeLim,

It is a CSV with that hex as the delimiter, I can include a screen shot.

[apathetichell]

throw all your fields in a multi-field formula. select them all. deselect new.

use this formula:

ReplaceChar([_CurentField_],CharFromInt(9617),"|")

use a recordid. text to columns (split on rows) use | as your delimiter.

better?

[keith-barber]

@apathetichell thanks for the response.  I used your suggestion, however the multi-field formula didn't replace.

[apathetichell · Accepted solution]

You posted a different character here - for your character you should use:

ReplaceChar([_CurrentField_],CharFromInt(145)+"%","|")

[keith-barber · Accepted solution]

@apathetichell yes that worked, thank you!  Tips on how I can get the data into rows and columns?  I've been trying to use the cross tab but stuck1/

[apathetichell]

so here's the output - but this isn't right. Problem is the split is off. Can you go back to the ingestion and see some options (ie where it originates from...)

[BS_THE_ANALYST]

@keith-barber @apathetichell perhaps this solves the split off issue? Could be completely misunderstanding though

[keith-barber]

Thanks @apathetichell , I liked the use of the tile tool.