I'm trying to parse a flat file with a special delimiter that I pulled from hadoop. It's called the ^A character but that didn't work. I've already tried: ?\u0007? These don't work in talend: \u0000, '\u0000', "\u0000", ^@, ^A. Anyone got this working?
More attempts that don't work:
'\0'+"" and '\0'. Notepad++ shows this nonprintable character as SOH character. Any ideas how to properly identify this?
Ok finally got it thanks to http://mindprod.com/jgloss/ascii.html. for tFileInputDelimited set the delimter as: Character.toString('\1') . It chokes if you just put in '\1' so you have to turn it into a String first.
