FCC for Broken pipe delimited file

[former_member207622]

Hi Fellow SDNer's

I have a broken pipe delimited flat file . I want to do file content conversion for the same .

Can you please help me with the parameters

I am on PO 7.4 dual stack

Thanks

Ninad Sane

[engswee]

Hi Ninad

You just have to specify the delimiter in the field separator parameter like below:-

<LineType>.fieldSeparator =  <delimiter>

Example:-

Header.fieldSeparator = |

For more details on content conversion, you can search and find many examples on SCN.

Rgds

Eng Swee

[former_member207622]

This works for pipe delimited flat file and not for broken pipe

eg -

DETAIL¦9999¦2099-04-24¦1¦500271¦xyz¦abc¦uvw

Any other suggestions?

Regards

Ninad

[Former Member]

Hi Niand,

What is the occurrence of the structure. Make sure that the neglected field with values to be as optional fields and try.

Follow the FCC like below:

<linetype>.fieldNames: <fieldnames>

<linetype>.keyFieldValue : <if any>

<linetype>.fieldSeparator : |

<linetype>.endSeparator : <ifrequired>

Hope this might help you...

[engswee]

Did you try putting the broken pipe character as the delimiter in the module? Just copy and paste it there. Do you get any error in the communication channel?

Rgds

Eng Swee

[engswee]

Hi Ninad

It looks like the broken pipe character is outside the US-ASCII character set.

ASCII Code - The extended ASCII table

You can try using the ASCII character to see if it works or not:-

Header.fieldSeparator = '0xA6'

Check also the following thread that mentions the use of non US-ASCII character.

In particular, it mentions OSS note 1936206 - if you have the corrections in place, you can try using MessageTransformBean and specifying the encoding with the following additional parameter.

xml.fieldSeparator.encoding=ISO-8859-1

Rgds

Eng Swee