Field Seperators for File Adapter Missing , If Data in field is Initial

[Former Member]

Hi All ,

I am working on Idoc to File Adapter Scenerio , The Issue is if one of the field is Initial , then the seperator(|) does not appear .

eg: if I have f1,f2, f3, f4 ... f10 columns

v1,v2.......v10 are the values , If v3, v4 values are initial , the file has only 8 fields and number of field seperators are 7 and not 9 .

In the content conversion parameters , i had specified the

Row.fieldSeparator |

Row.endSeparator 'nl'

Row.fieldNames f1d1|fld2|....|Fld10

Please advice

Regards

Chan

[STALANKI]

Chan,

It definetly accepts just press the space bar,save and activate and test.!

[Former Member]

Dear Moorty ,

I am usings exits along with if-else , but to the constant if i assign a space it does not accept . Please suggest .

Dear Satish ,

I am using csv and its not an eroor , hence no error message .

Best Regards

Chan

[Former Member]

HI,

You can use 'Creatif' to create a node if there is no node exisitng.

regards

Vijaya

[Shabarish_Nair]

Chan try this,

<field> -> exists -> if then else

if then -> give your field

if else -> a constant (space or empty string)

and map this to your target

This sud work !!!

[Former Member]

Chan

Can you tell us whether you are looking for a .csv file or for fixed length file? Also can you tell us the error message what you are getting in SXMB_MONI.

Regards,

---satish

[moorthy]

HI Chan,

Because if there is no value in the idoc fields , it will not generate XML tags for that. So you will get only 8 xml tags in your input xml.. Check this from SXMB_MONI->Input xml(Idoc xml).

For this you can make use of <b>Exists</b> node function in the mapping, with <b>If-else</b> functions. So if it exists map directly else map with constant value. So that you will get all the xml tags, so that all the fields..

Regards,

Moorthy