Variable field manipulation
Moderators: chulett, rschirm, roy
Variable field manipulation
Hi,
The following is my field structure:
201106;4000;160,50;12345678
200106;4008;6,50;12345679 etc..
I have to load these into a Dataset. I have used a transformer for extracting the field info like Input.Fileinput[1,6] like wise and loaded the first two columns in the Dataset. but for the third column i am not knowing how to extract the data as they are of variable length. The data in the third column should be treated as decimal with scale of 2 digits.
It is a parallel job and let me know how to load the remaining columns.
I am new to this forum and this is my first post.
thanks,
JJ
The following is my field structure:
201106;4000;160,50;12345678
200106;4008;6,50;12345679 etc..
I have to load these into a Dataset. I have used a transformer for extracting the field info like Input.Fileinput[1,6] like wise and loaded the first two columns in the Dataset. but for the third column i am not knowing how to extract the data as they are of variable length. The data in the third column should be treated as decimal with scale of 2 digits.
It is a parallel job and let me know how to load the remaining columns.
I am new to this forum and this is my first post.
thanks,
JJ
Define 4 columns in the column definition of seq file stage with type varchar, put some number in lenght field and nullability no.
Set delimeter to semicolon.
I tested one job at my end with below data in seq file and it worked fine.
201106;4000;160,50;12345678
200106;4008;6,50;12345679
Are you able to view data from sequential file stage?
Set delimeter to semicolon.
I tested one job at my end with below data in seq file and it worked fine.
201106;4000;160,50;12345678
200106;4008;6,50;12345679
Are you able to view data from sequential file stage?
Arvind
Hi,arvind_ds wrote:Define 4 columns in the column definition of seq file stage with type varchar, put some number in lenght field and nullability no.
Set delimeter to semicolon.
I tested one job at my end with below data in seq file and it worked fine.
201106;4000;160,50;12345678
200106;4008;6,50;12345679
Are you able to view data from sequential file stage?
This works
Just for Information why i cant the get when i am trying to see the whole file as a single string and then separate the same?
if possible let me know.
thanks once again.
JJ
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: