Hi,
I have a file in the below mentioned format.
UHDR1
1234567890 AB1CD12345 ABCDEFGH ABC@ABC.COM
UTRL1
Since the Header and Tralier Format is going to be the same for all the files,I am creating a template job to remove the Header and Tralier.
Below is the design
1.Read all the records as a row using the datatype as Varchar(8000)
2.Using the following formats(000 as delimter and 000 as quote character).As some files also contain datas which has ,.* etc
3.Read the trmmed file as a fixed width file with appropriate metadata.
4.For the above mentioned file alone it is not able to read the entire record.
To be precise it is able to read till
1234567890 AB1CD12345 ABCDEFGH
then it throws the warning(view data
)
ext_trim_Header_trailer_mlol_consent..Seq_Input.InFrmSeq: read_delimited() - row 1, too many columns in record
If I use other delimiter it is able to read it.
My speculation is some NULL character is appearing in the file after that part of the record.Kindly let me know if my speculation is right.
Also suggest me some delimter which is hard to come by in the file(I have changed it to ^).
Thanks in advance.
Regards,
Bala.
Reading through the delimter 000
Moderators: chulett, rschirm, roy
Hi,
Thanks Craig.
I cant enable the supress row truncations as data is not read fully.
I have used some of the delimters(144 or 161) suggested in the below link.These are very rare to come from the source.
No worries my data is Engish not french
http://www.asciitable.com/
Out my curiosity where can we find the allowable delimiters for datastage.Because not all extended ascii values are working(eg :128 throws error.
Thanks once again.
Regards,
Bala.
Thanks Craig.
I cant enable the supress row truncations as data is not read fully.
I have used some of the delimters(144 or 161) suggested in the below link.These are very rare to come from the source.
No worries my data is Engish not french
http://www.asciitable.com/
Out my curiosity where can we find the allowable delimiters for datastage.Because not all extended ascii values are working(eg :128 throws error.
Thanks once again.
Regards,
Bala.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: