Skip to Content
0
Former Member
Jan 20, 2011 at 03:10 PM

Pass a Comma for a blank value in CSV

129 Views

Hi,

I need to post the data from a Proxy to the CSV file in UTF-8 format.

All the fields on target are mandatory and sometimes I may not have the values from the source. Then, a comma(,) has to be sent for that particular field in the target.

I tried doing with MapwithDefault with a Comma(,)

If the field value does not exist, then passed a Comma(,) from a constant.

Both of the above doesnt work and I get a blank in the target field.

When I used FIXVALUES for another field, I'v put a comma(,) in default. Then it works. But if it is without FIXVALUES, Fails.

Please help.

Regards,

Taro