Talend community forum / What delimiter to use with hadoop files

darian3118 · 2012-06-12 07:07:20

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?

darian3118 · 2012-06-21 02:04:06

More attempts that don't work:
'\0'+"" and '\0'. Notepad++ shows this nonprintable character as SOH character. Any ideas how to properly identify this?

darian3118 · 2012-06-21 03:03:32

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.

Last edited by darian3118 (2012-06-21 03:03:56)

Announcement

Unanswered posts

#1 2012-06-12 07:07:20

What delimiter to use with hadoop files

#2 2012-06-21 02:04:06

Re: What delimiter to use with hadoop files

#3 2012-06-21 03:03:32

Re: What delimiter to use with hadoop files

Board footer