File sender - carriage return and new line as endseparator

[Former Member]

Hi All,

I'm stumbled with a problem to set carriage return and newline character as the endseparator (record delimiter)

Scenario: The input file PI is receiving has got few fields which has text in it and the content in this text has got newline characters. So to identify record separator, at the end of each record the combination of carriage return and new line is added.

In file sender content conversion I've set the folllowing parameters to achieve this:

Row.fieldSeparator : , (comma)

Row.endSeparator : '0x0D''0x0A'

Problem: In my sample input file, the first row has a text field with a newline character. When executed PI is splitting the record at the newline character in the text field (instead of combination of carriagereturn and newline which is set in the endSeparator paramter).

Pls advice on how to resolve this .

Happy Holidays!!

amar

[Former Member]

HI,

Based on the OS newline character will be used or generated by the application...

better do a end to end testing in this case ...i,e instead of getting the file to local machine or you generating and doing a testing...

test the scenario as a whole which needs to be executed in PRD environment....

But the endseparator u specified will work...as i have used the same in case of receiver adapter and i didnt have any problems

HTH

Rajesh

[Former Member]

Rajesh..Thanks for your quick response

I'm trying with the actual file being provided by the trading partner. I did not generate the file nor changed the file..

Before identifying the combination of carraige return and new line, the adapter is splitting the record when encountered with new line character within one of the text fields.

As you said it worked for you, you do have new line characters within fields in a record?..pls throw some light..let me know for any information..

Thank you

amar--

[Former Member]

Hi Amar,

I think you can add field.fixedlength parameter which can resolve your problem.

Regards,

Nutan

[Former Member]

Nutan,

My file is comma delimited , it is not in fixed field format. Am I missing some thing here..pls let me know

Thanks