Blank field is inserting while importing by using dataport from CSV file

Business Central/NAV Developers Forum
1

While I am trying to insert new field by using dataport one blank coloumn is inserting in between the dataport fields. If anybody can help me to sortout this issue, it is highly appreciatable.

Thanks&Regards,

Jithin Mathew.

2

Hi

Try to import from csv file not from text file, if you have your data in text format then paste it in excel sheet and covert the excel sheet as csv , and then try to import.

keep the FieldStartDelimiter = TAB.

Thanks

Jerome Marshal.J

3

Just check in data if there is comma in characters as you are using CSV file. Check that

Best way go for Tab delimited file.