Microsoft Dynamics NAV (Archived)

XMLPort double quotes

(0) Share

Report

Posted on by Community Member

I have made a XMLPort which import some data from CSV file which is semicolon seperated.

I works fine, until the use of double quotes in the csv file. Then it will divide it into 3 fields.

This is what it looks like in excel before save as

MS "Foo Luna" (ex Foo Sky).

The CSV file looks like this when opened in note

66848;31.08.2016;"MS ""Foo Luna"" (ex Foo Sky)";89870900594;

How do I work around this, so i can insert it so after insert is still with double quotes?

*This post is locked for comments

I have the same question (1)

All responses (13)

Answers (0)

Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello Christopher007,

Design the XMLPort and goto properties

Then Set the bellow properties as per your requirement

FieldDelimiter

FieldSeparator

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have the following properties set. The FieldDelimiter is standard, the FieldSeparator i have set custom.

FieldDelimiter <">

FieldSeparator ;

What should i change it to to have names with double qoutues added without making it divide into 3 different fields?

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Properties. Value

FieldDelimeter ;

FieldSeperater. ;

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

As suggested by Binesh try once and the semicolon in both the values i.e. Field Delimiter and Field Separator

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

Try to use 'TAB' delimited file

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The customer wants to use semicolon delimited file, I have suggested 'TAB'.

Binesh

It come in like this with your suggestion.

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello Christopher007,

See the bellow screenshot. and let me know what you have issue, what you want to change.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Binesh,

The customer wants to use semicolon seperator.

Issue is the customer name is the following - MS "Foo Luna" (ex Foo sky)

When i import it from CSV file it gets like this - "MS""Foo Luna"" (ex Foo Sky)"

or it get devided into 3 fields - MS - Foo Luna - (ex Foo sky).

Can I get it into NAV with semicolon seperator and still look like this MS "Foo Luna" (ex Foo sky)

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (1)

Report

Hello,

Look if in your data " double quote is there then you can't use FieldDelimiter as a " Double quote, because system whenever found " double quote then it terminate for next.

Tell to customer export data as some other delimiter that delimiter is not exist in actual data Like- ; OR * OR any special symbol that are not exist in actual data.

and based on csv create Xmlport and now Import/Exort, so you won't get any exception.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am not using FieldDelimiter as a "

I use semicolon. 66848;31.08.2016;"MS ""Foo Luna"" (ex Foo Sky)";89870900594;

Maybe there is a way to save the without adding the extra double quotes to the csv file? so the CSV file is like this

66848;31.08.2016;MS "Foo Luna" (ex Foo Sky);89870900594; ?

Was this reply helpful? Yes No