Skip to Content
0

File Delimiter change in a pass through Scenario

Aug 09, 2017 at 01:55 PM

87

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Evgeniy Kolmakov Aug 09, 2017 at 05:25 PM
5

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.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hi Evgeniy,

We will try that option.

Thanks for your inputs!

Regards,

Marc.

0
Former Member

Very creative, I didn't think of that :-)

1

Thanks, Partick!

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

Regards, Evgeniy.

0

Great Thought Evgenly..! :)

1

Hi Avinash!

Thank you very much for your positive feedback.

Regards, Evgeniy.

0
avatar image
Former Member Aug 09, 2017 at 02:01 PM
1

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Patrick,

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

Thanks for the advice!

Regards,

Marc.

0