Import dataport problems with special char

selece28

Hi Nav Masters,
I have a problems with my dataport.
When importing Data, my clients data consist of special char like "
They use it for writing 'inch' so instead of <14 Inch> they write <14">
After run my dataport, the result will be incorrect because navision think " as separator.
I Already set the delimiter in my dataport from <"> into <None>
But still it cannot import correctly.

Any idea how to import this character?

Thanks in advance

JedrzejT

If this file is in standard import format *.csv then you should replace all (") sign to (') before import file.
If you have (in import file) field separator (") and have (") sign in filelds value dataport can not import that in standard way.
When i create csv file I always replace (") on (') and (;) on (,)

You can replace later (') on (") in code of dataport to have this in database but this is not good idea. When You have (") in table then you can not copy and paste data to excell.

Regards

selece28

I just find out that Navision cannot import "
so in csv we have to replace " with other char like ^
the with the import dataport we should use CONVERSTR to replace ^ back into "

Thanks

Malajlo

Use different char for field separator. Ie ÷פ~ˇ.