You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » how to read data with variable number of columnes
#1 2011-09-29 10:36:47
- zhanghao_france
- Guest
how to read data with variable number of columnes
Hi,
I have a file input like this:
AF007;3;2;1;Jim Green;2;Tom Crous;3;Li JET;1;CDG;2;PKN
AF681;2;3;1;Jack Lavigne;2;Julien Roux;1;CDG;2;AMS;3;PKN
the format is:
<flight>;<number of passager>;<number of airports concerned>;<liste of passager>;<list of airports>
<liste of passager> and <list of airports> have a variables number of fields, it depends en flight
With TOS, we can read and write this kind of files?
Thx
#2 2011-09-29 10:39:47
- zhanghao_france
- Guest
Re: how to read data with variable number of columnes
It's like the vector in C, but I don't know if we have the same thing in TOS.
#3 2011-09-29 11:16:05
Re: how to read data with variable number of columnes
zhanghao_france,
You could use the tNormalize component if you would seperate the list differently. So you would consider the list of passengers as 1 column. (For example seperate them as comma's)
For example The list of passengers with comma's :1,Jim Green,2,Tom Crous,3,Li JET
AF007;3;2;1,Jim Green,2,Tom Crous,3,Li JET;1;CDG;2;PKN
But that's the only solution I can come up with.
Regards
Last edited by mpa (2011-09-29 11:16:22)
Offline
#4 2011-09-29 11:32:49
- zhanghao_france
- Guest
Re: how to read data with variable number of columnes
Hi mpa,
Thanks for your reponse.
If I have always the same seprators ';' in a input file, I can't see how I can read it.
And if I treat the list of passagers like one field, I'll have to extracte the contente each time I deal with it.
I guess it'll not be performant.
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » how to read data with variable number of columnes