Skip to Content
0
Former Member
Jan 23, 2012 at 12:20 PM

Replace String in csv file with file adapter content conversion

402 Views

Hello experts,

I have a sender file channel to receive csv files from an external server. I can process the csv files but I have a little problem. Since the separator in the csv file is a comma and sometimes a comma also appears in the dates but this time it is not a separator.

Example:

1234,20120123,ABCD,customer, which has a comma in it's name,...

5678,20120123,FGHI,customer without comma,...

My plan is to remove all commas when a blank follows.

My current content conversion looks like this:

Record.fieldNames field1,field2,...

Record.fieldSeparator ,

Record.endSeparator 'nl'

Is there something like Record.fieldReplaceString or something similar which I can use? Or is there perhaps a better way to do this?

I'd appreciate every help I can get here.

Best regards.

Oliver.