Before I start, let me say that I am looking forward to seeing lots of my readers next week at Inspire. You will most often find me in the Solutions Center. Please don’t hesitate to come ask questions, give suggestions or just chat. I love the opportunity to teach & learn.
Recently I got a question on our internal support board: How do I parse a file that is Ctrl-A delimited? Normally for reading delimited files you just read the file as a CSV and set the delimiter in the input settings and you are done. The problem with Ctrl-A is that it is a special (unprintable) character and it is not possible to set in the GUI. The normal backup for parsing issues like this – the Text To Columns tool – has the same limitation. Continue reading