First line not coming when FCC is used

[former_member206760]

Dear All,

I am using FCC on sender side and the input file is in UTF-8 format....

i am using FCC with key fields on the sender file adapter...

now as the UTF-8 file was having control characters at start the keyfield was not matching the start of file and hence the first line of data was not coming in moni..

i got an answer to this query yesterday where Stefan Grube and Volker replied saying that some of the editors like notepad and word add control chars at start in UTF-8 files and hence UTF-8 files should be created only using editors like TEXTPAD .....

but the problem is that the file would always have control chars at start.. what are the ways of removing it ?

i am thinking of an adapter module at the sender side...

Edited by: Tarang Shah on Jun 11, 2009 6:31 AM

[Shabarish_Nair · Accepted solution]

the best way would be to use a simple adapter module and remove that character.

[former_member206760 · Accepted solution]

guys ,

any other views

[former_member206760 · Accepted solution]

any other options guys,

i think adapter module would be the best option

[Former Member]

Hi,

I faced this kind of problem previously.

Have used SynTextEditor in which the hidden/special/control chars are clearly visible, delete those chars and use for input.

Alternatively, you can save the file in UTF8 format in textpad and use as input.

Regards

[former_member206760]

Dear Ravi,

I know that we can save the file in textpad and the issue will not occur but

this option is not feasible as the sender system is not ready to do that...

Any other options..

[Former Member]

Hi,

Try to define 2 recordstructures in FCC where in the First record structure reads the first line of the source file and the second structure starts reading the source file from 2nd line.

Thanks,

Kiran

Edited by: Kiran on Jun 11, 2009 11:01 AM

[former_member206760]

Dear kiran,

I am doing the same but the keyfield that is used doesnot match with the control chars at the start of first lilne and hence first line doesnot appear in moni

[sunilchandra007]

Hi,

Instead of going for Adapter module, you can simply write an OS script that would remove the control characters before processing the file.

Regards,

Chandra