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
Solved! Go to Solution.
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.
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?
@apathetichell thanks for the response. I used your suggestion, however the multi-field formula didn't replace.
You posted a different character here - for your character you should use:
ReplaceChar([_CurrentField_],CharFromInt(145)+"%","|")
@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/
@keith-barber @apathetichell perhaps this solves the split off issue? Could be completely misunderstanding though
Thanks @apathetichell , I liked the use of the tile tool.