fieldSeparator for .xlsx files

[former_member260907]

Hi All,

I am taking .xlsx files with file adapter. Is there anyone knows what fieldSeparator is for it? I am using fieldSeparator = '0x09'  and getting an error saying "

An invalid XML character (Unicode: 0x19) was found"

Any help would be appreciated.

Charles.

[vadimklimov · Accepted solution]

Hello Charles,

It is not possible to parse Excel files using standard File adapter, unless you enhance it with custom adapter module for processing such files. But if it is possible for you to substitute usage of XLSX files with their CSV analogues, then valid delimiter for tab is \t.

Regards,

Vadim

[former_member260907 · Accepted solution]

Hi Vadim,

You mean if I save it as csv file with tab, I set fieldSeparator = '/t' would work?

Thank you!

Charles

[nabendu_sen]

Hi Charles,

For custom adapter module, you can check:

Also check discussion thread:

Regards,

Nabendu.

[former_member260907]

Hi,

I can save it as csv file, But when I set fieldSeparator = '/t' or fieldSeparator = ',' , or fieldSeparator = '0x09'. It does not separate the field.

Anyone knows what the separator should I use?

Thanks,

Charles

[former_member260907]

Resolved. I saved it as tab delimited txt file.