Delimited file account schema shows extra character

[maniG (Manisha Gupta)]

Hi all

During discover schema, iiq adds extra character in attribute name for account schema in Delimited Files connector

If I add the schema columns myself, the column values dont show up in the preview

I am adding a screenshot here

How do I correct this

Thanks

[harrypatrick]

Check to see if the CSV has the same space. If it does, you would typically have the upstream system correct it.

[dheerajk27 (dheeraj kumar)]

Hi @maniG ,

Open delimitated file in notepad++ you should see the special character there, you need to remove it and save. this should solve you issue.

[mercury (Keith Smith)]

The issue is you have the UTF-8 Encoding with BOM file format. I have seen this so many times. If you are saving the data from Excel you have to use the second CSV option which is just the plain Comma Separated (CSV) option.

• CSV UTF-8 (Comma Delimited) (*.csv) - BAD
• CSV (Comma Delimited) (*.csv) - GOOD
• CSV (Macintosh) (*.csv) - BAD
• CSV (MS-DOS) (*.csv) - BAD

If you want to see for yourself, pull up the Notepad++ Hex editor and examine the file. You should see 3 characters at the beginning like this:

That’s the BOM.

Hope this helps.

[maniG (Manisha Gupta)]

Thank you so much everyone
@mercury, that’s the solution