Query on FCC File Receiver

[Former Member]

Hi Experts,

In our Scenario the receiver is File FTP.

While doing FCC, we have use ';' as the default delimiter. Now our requirement is when the default delimiter (semicolon) is present in a field value we need to use '@' as the delimiter.

Can you please suggest how to configure the same in the same in the receiver FCC File Adapter.

Thanks

Suganya.

[Former Member · Accepted solution]

Hi,

I dont think you can set the delimiter value dynamically based on the input you receive...

better to proceed with other way that is replace ; with @ in the field value itself..

this need to be handled in mapping part..use indexOf and replaceValue..

one more best thing will be to handle the same in the sender system itself which is sending this data...

HTH

Rajesh

[Former Member · Accepted solution]

Thanks for the reply.

But we need the delimiter to be changed only in the output txt file based on the input field value without disturbing the field value. Hence we wont be able to change by mapping transformations.

So i guess it is not possible.

Can you please confirm on the same.

Thanks

Suganya.

[Former Member · Accepted solution]

Yes with the standard functionality you cannot achieve the same..

Regards

Rajesh

[Former Member · Accepted solution]

If you are aware of any other additional possibilities for the same kindly do let us know without fail.

Thank you so much for your quick response.