topic Re: How to read file having \x01 delimited in Talend Studio

How to read file having \x01 delimited

Anonymous — Fri, 11 Oct 2013 18:00:12 GMT

Hi,
I am trying to read files having \x01 delimited but I am getting error as invalid excape. Please help.
THank you.

Re: How to read file having \x01 delimited

Anonymous — Sat, 12 Oct 2013 05:25:11 GMT

Hi,
Could you please show us some fragment of your input file so that we can know your situation more precisely.
Best regards
Sabrina

Re: How to read file having \x01 delimited

Anonymous — Sun, 13 Oct 2013 13:14:24 GMT

The delimiter in the tFileInputDelimited as a Java String. What ever is necessary to declare your delimiter as Java String is the right thing to setup the component.
Use that as field delimiter:
String.valueOf(Character.toChars(01))

Re: How to read file having \x01 delimited

_AnonymousUser — Mon, 14 Oct 2013 06:14:52 GMT

Hi,
Following are some sample records of the file -
50882013-05-28114
50882013-06-11135
50882013-06-26175
50882013-07-01141
50882013-07-02181
50882013-07-0311
50882013-07-03125
50882013-07-03131
50882013-07-03171
50882013-07-0571
"\x01" is an invisible delimiter which cant be typed from keyboad. this file is generated by Ab Initio and we are trying to read this file but we are not able to. Here is the file format -
record
utf8 string("\x01", maximum_length=4) whse /*VARCHAR(4)*/;
date("YYYY-MM-DD")("\x01") date_time /*DATE*/;
decimal("\x01") date_hours /*INTEGER*/;
decimal("\x01") cartoncount /*INTEGER NOT NULL*/;
string(1) newline = "\n";
end
Please help me on this.
Thanks,
Madhusudan

Re: How to read file having \x01 delimited

Anonymous — Mon, 14 Oct 2013 07:26:50 GMT

can you show us hexadecimal view of record,

Re: How to read file having \x01 delimited

Anonymous — Fri, 03 Aug 2018 16:48:49 GMT

To read the AbI file delimited by Ctrl+A, you can use "\001" as field delimiter.

Re: How to read file having \x01 delimited

Anonymous — Mon, 04 Nov 2019 21:29:04 GMT

Is this problem resolved ?

I'm asking because I've to deal with similar scenario where I need to replace all \x01 in data by empty string. Please suggest.

Re: How to read file having \x01 delimited

Anonymous — Fri, 17 Jan 2020 22:12:37 GMT

you can use replace function

myValue.replaceAll("\u0000", "")

myValue.replaceAll("\001", "")