Sender File Adapter Ignore Last Line

[Former Member]

Hi All,

Like in Sender File Adapter configuration like we have Document Offset to specify the number of starting lines to be ignored,

Like the same way can we ignore the last line of a text file .

Regards,

Rahul

[cdumont69 · Accepted solution]

Hello,

If each line begin with a key, I think you can use the key : fieldName and ignore the last line with a special key.

<u>See these weblog :</u>

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Regards,

Chris

[bhavesh_kantilal]

Rahul,

I dont think there is a standard way to achieve this.

Any special reason for this?

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

I somehow wait for your answer,

Nothing special ..i just want to ignore the last line,,

i can always create a structure and then simple read the data and ignore it..

thought if theres any standard way ...

btw ..

suppose in a flat file..

i just want to read the 4th line??

is there any way i can do this?

Thanks

Rahul

[bhavesh_kantilal]

Rahul,

><i>I somehow wait for your answer,</i>

Is that a compliment

I guess there is no standard way to ignore the last line . Like you pointed out, read the line and ignore it in the mapping!

><i>btw ..

suppose in a flat file..

i just want to read the 4th line??

is there any way i can do this?</i>

Again no straight forward way to do this. You can use KeyFields etc , but there is no direct way to do this and every solution would depend on the exact requirements!

Regards

Bhavesh

PS Are the alerts issues resolved?

[Former Member]

Hi Bhavesh,

That sure is a compliment.

I dont know why i get weird weird problems ..

The alerts issue are still not resolved. I am thinking still what to do.

I have asked Basis to apply SP10 and if still the issue is not resolved i will raise OSS message.

Thanks

Rahul