File Delimiter change in a pass through Scenario

[mdejesus]

Hi Experts,

We would like to ask your inputs with regards to our scenario - File Delimiter change (Tab to Pipeline) in a pass through Scenario.

We came up with two possible solution:

1. Use Java mapping to replace delimiters

2. User FCC sender to FCC Receiver (without mapping)

Which of the two solution would be best option for handling large files? (Maintainability wise, option 2 is much better)

Let us know your thoughts.

Regards,

Marc.

[former_member190293 · Accepted solution]

Hi Mark!

Another option is to use MessageTransformBean in sender adapter twice: convert into XML and convert back to flat file with another delimeter.

Regards, Evgeniy.

[mdejesus · Accepted solution]

Hi Evgeniy,

We will try that option.

Thanks for your inputs!

Regards,

Marc.

[weberpat · Accepted solution]

Very creative, I didn't think of that 🙂

[former_member216164 · Accepted solution]

Great Thought Evgenly..! 🙂

[former_member190293 · Accepted solution]

Thanks, Partick!

I just fell too lazy to reinvent the wheel 🙂 I've used the same approach couple of times before.

Regards, Evgeniy.

[former_member190293 · Accepted solution]

Hi Avinash!

Thank you very much for your positive feedback.

Regards, Evgeniy.

[weberpat]

You could use a simple adapter module like this one or a pre/post-processing script to do a search and replace.

If you have to handle large files, you want to avoid passing them through a mapping whenever you can.

[mdejesus]

Hi Patrick,

We will remove the option with mapping since we will be handling very large files.

Thanks for the advice!

Regards,

Marc.