datasource is notepad
Moderators: chulett, rschirm, roy
datasource is notepad
Hi all,
I am getting data in notepad ...I have file format which defines what every line means ,
data is as follows:
1
UNCERTIFIED - 5 YEAR
-
12345 12345 123450
- NJ DEPT OF TRANSPORTATION
xxxxxxxxxxxxxxxx
xxxxx xx xxxxx
-
122456 07 16 2008 x
0 DRIVER NOT FOUND
1
UNCERTIFIED - 5 YEAR
-
12345 12345 12345 xxxx x xxxxxxxxxx
0 xxxxxxxxxxx xxxxxx xx xxxxxxxx
- NJ DEPT OF TRANSPORTATION D
xxxxxxxxxxxxxxxxxx
xxxxxx xx 12345 12 31 2011
-
AB030290 07 16 2008 A
0
0 NO VIOLATION RECS FOUND FOR DRIVER
0 CURRENT STATUS - IN GOOD STANDING
thus lines continues with more records.....
.............................................
I am really not sure how to load this file .............I have mapping which says hot to load particular field :line no. what is the length of field .......start position.
Please provide me the input ........if the requirements are not clear( i did not understand too) pl let me know ,
Thanks
I am getting data in notepad ...I have file format which defines what every line means ,
data is as follows:
1
UNCERTIFIED - 5 YEAR
-
12345 12345 123450
- NJ DEPT OF TRANSPORTATION
xxxxxxxxxxxxxxxx
xxxxx xx xxxxx
-
122456 07 16 2008 x
0 DRIVER NOT FOUND
1
UNCERTIFIED - 5 YEAR
-
12345 12345 12345 xxxx x xxxxxxxxxx
0 xxxxxxxxxxx xxxxxx xx xxxxxxxx
- NJ DEPT OF TRANSPORTATION D
xxxxxxxxxxxxxxxxxx
xxxxxx xx 12345 12 31 2011
-
AB030290 07 16 2008 A
0
0 NO VIOLATION RECS FOUND FOR DRIVER
0 CURRENT STATUS - IN GOOD STANDING
thus lines continues with more records.....
.............................................
I am really not sure how to load this file .............I have mapping which says hot to load particular field :line no. what is the length of field .......start position.
Please provide me the input ........if the requirements are not clear( i did not understand too) pl let me know ,
Thanks
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
I have to read this file ,
every record starts with 'UNCERTIFIED - 5 YEAR' then I have 8 lines following that header , I m planning to create staging table to store these 8 lines into 8 columns thus store first record , when i hit 'UNCERTIFIED - 5 YEAR' again that means its 2nd record ......8 lines .......8 columns .......
I am not sure how to do it in datastage ............
every record starts with 'UNCERTIFIED - 5 YEAR' then I have 8 lines following that header , I m planning to create staging table to store these 8 lines into 8 columns thus store first record , when i hit 'UNCERTIFIED - 5 YEAR' again that means its 2nd record ......8 lines .......8 columns .......
I am not sure how to do it in datastage ............