Tab separated flat file

[Former Member]

Hi All,

I am facing a problem at the time of receiver file adapter(tab separated). I have given in the fieldSeparated as '0x09' but it takes '#' in the file. please help me if any body knows.

Regards

Govinda.

[Former Member · Accepted solution]

Hi, Govinda

If you pointed only fieldSeparator '0x09' then try next variant in receiver FCC.

Recordset Structure: head,item (i don't know your structure)

head.fieldSeparator 'nl'

item.fieldSeparator '0x09'

item.endSeparator 'nl'

[prateek]

Open blank notepad and press tab. Copy and paste the space covered by single tab to the FCC configuration and try again.

Regards,

Prateek

[Former Member]

Thanks for reply Immediately...I have tried that one also but still i am getting the '#' separated file.

Regards

Govinda.

[Former Member]

Hi Govind,

check in FCC is it UTF-8 or some other

thanx

Sampath

[Former Member]

Hi sampath,

I am not getting you. can u plz tell me the where i have to check the UTF-8.

Thanks

Govinda.

[SudhirT]

Hi Govinda,

It means ,Check your sender Communication channel if the value of file type parameter you have selected is Text instead of Binary?

Thanks!

[Former Member]

Hi,

I am using file adapter in the receiver side. shall i change the 'File Type' parameter Binary to Text?

Thanks

Govinda

[SudhirT]

Noooo, I meant to say dont change it , keep it as binary.

Thanks!

[Former Member]

Hi,

Still I am not getting Tab separated file. Please anybody help on the.

I have given:

Record.fieldSeparator ---> 'nl'

Row.fieldSeparator -

---

> '0x09' and tried copy the tab in the notepad and passte it.

Row.endSeparator -

---

>'nl'

But i am getting the # separated file. Plz let me know if any thing wrong in that and do i have to give any parameters.

Thanx

Govinda.

[Former Member]

Hi Govinda,

Please Try again with this:

Row.fieldSeparator -

---

> '\t'

Ivan.

[Former Member]

Could be due to cache issue. In ID from menu "Environment --> Clear SLD Data Cache" and then try.

[SudhirT]

Hi,

You can try like this, Open the notepad and press tab , copy this space and paste in fieldSeparator value.

Thanks!