on 09-08-2009 3:15 PM
HI,
I am working on IDOC to Flat file and wondering how can I eliminate the empty space in the flat file if IDOC doesnt send the values in the fields?
Suppose flat file strcuture is :
Row
-Name
-Age
-City
There are some rows where are no age values then I dont have empty space in between the rows:
A|20|Banglore
B| |Mumbai
I want to skip the field if there is no values passed.. is it possible?
Thanks
Rajeev
Hi Raj,
It is the default functionality, by default if the source value is not come then automatically you will get the next field value (if delimeter exists then the delemeter comes) like whatever you mentioned
A|20|Banglore
B| |Mumbai
Sathish suggested use MapWithDefault option, that is also good one. you can map that node function to all the fields. double click on that node function and dont give any value even space also then you will get the required output.
Regards
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can also give a try with below mentioned parameter in your FCC..
>>Age.fieldContentFormatting = trim
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rajeev,
Yes it is possible with the standard content conversion parameters only. If no age is present then your output will be like you mentioned only. But if you want space if no value is present then in mapping you can use an exists function. So if the source field exists then send the field else you can send spaces if you want. Also instead of this you can use mapwithdefault, so if source field doesnot present it will send the value whatever you have in mapwithdefault.
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
If you want to do automatically, You need to develop a javamapping which delete the empty tags.
Regards
Ivan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.