Tab delimated file pattern read
Moderators: chulett, rschirm, roy
Tab delimated file pattern read
I have 3 differetn files with same format, they have , FH,BH,DL,SA,CC,BT,FT records, i have to pass them to seven different files which have only taht record along with their filenames, in transformer what condition should i put in order to make the records go into only those respective link, if it were fixed width i would give link.recordtype[1,2]=FH then go this link, but this is tab delimated, in this case how do i do that, any ideas
sameer
Really, you'd do basically the exact same thing. However, I would guess you'd just need to check the first field rather than substring anything but that will depend on how you have defined the file metadata.
Also... periods are your friend. Don't be afraid to use them.
Also... periods are your friend. Don't be afraid to use them.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
The Syntax is Index (string, substring, instance)
Make n number of links out to transformer.
In each link add a constraint which you need to check.
link 1:- INDEX(COLUMN,'FH',1) <> 0
link 2:- INDEX(COLUMN,'BH',1) <> 0
link 3:- INDEX(COLUMN,'DL',1) <> 0
same way for all the data......
Hope this solves your problem.
Make n number of links out to transformer.
In each link add a constraint which you need to check.
link 1:- INDEX(COLUMN,'FH',1) <> 0
link 2:- INDEX(COLUMN,'BH',1) <> 0
link 3:- INDEX(COLUMN,'DL',1) <> 0
same way for all the data......
Hope this solves your problem.
Thanks
Chillblue
Chillblue