How to Ignore Multiple lines starting with "#" by using sender FCC?

[Former Member]

Hi Gurus

I am working on file to rfc scenario and i am receiving an Pipe Separated file and i am using the FCC. I want to ignore  Multiple lines starting with "#" by using sender FCC, what parameters should be given.

Please help

[Former Member]

Hi Gurus

my File is as follows

#DUNS NUM+3IEquipmentIDIso on till 18 fields

1234567890123I data for all the fields and so on for 18 fields

# All the records containing the data from the supplier by name----- there will be multiple lines in the file, i want to ignore these multiple lines.

My data Structure does not have Header and data , ;please suggest as i am struck development and its very urgetnt.

please help.

[Former Member]

Hi ,

You mean to say, In your | separated file you need to ignore the lines that starts with # ?

If yes ;then i don't think by standard fcc you can ignore the lines that start with #.

As above said look for either handling in module or in mapping .

Regards

Venkat

[Former Member]

Hi.

You can try two options.

Create a module on Adapter Channel.

Create a logic on Message Mapping to ignore the records starting with #.

Regards.

[Former Member]

Hi,

Below are some of the options.

1)Using sender adapter module.

2)Use FCC as below

In source structure Create only field as below

Header 0..unbounded

  Data  1..1

In FCC use field separator as new line and read entire file record by record. Now in mapping write small udf (rotate each record and pass the field values to actual structure (skip the records starts with #)) .

In 2nd mapping use the actual structure and map to your target.

My suggestion is go with module ;you can easily handle it .

Regards

Venkat