on 04-04-2010 4:46 AM
hi all,
I am getting one Flat file which I need to convert in xml before processing it in mapping. Below is the structure of the input file:-
dkghdgk
gkhdggg
ghdgkhdgk
46ffsfsf
:lgjdgdgg
$dfgxvnlkas
vnmvkvas;vasofjsfasfv
vbvgfpwtndfgdjgdgdfv
vnmvlddg jgkl jklk j l;
jhkg; gj klhjg njkdgggpr83jg
nhldggdgdggfgjhgfj
Number of rows in the file is not constant.
My requirment is to convert in such a way that first 3 rows should be assigned to first three fields and forth field should contain rest all data or in other manner. But first 3 rows must be in three seperate fields, rest all rows can be defined in any way.
Please let me know if it is possible in File content conversion. If not please tell the alternate way.
Thanks
Jai
Hi Jaideep,
But first 3 rows must be in three separate fields, rest all rows can be defined in any way.
Please let me know if it is possible in File content conversion. If not please tell the alternate way.
Is it fine if you read the flat file line by line and a temporary structure is created which will
have a field say Row under a node DATA,
row will repeat as number of times as there are lines in the input file.
later you can keep first three line as different fields and merge the remaining in a single field.
You may have to create two mappings to map it to the actual structure required .
Please refer this blog(see the screenshots in the blog)
/people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter
My requirment is to convert in such a way that first 3 rows should be
assigned to first three fields and forth field should contain rest all data or in
other manner.
so you can merge the 4 th row and onwards into a single field in the mapping
Regards,
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
23 | |
11 | |
9 | |
9 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.