08 May 2014

Data Import Export Framework escape text qualifier

If you want to import text with the DIXF (DMF) that is delimited with a text qualifier you Need to take care that the text qualifier does not accure within the text.

1;"example "test" text";123

This will lead to an error. Actually Microsoft suggests to use a unique text qualifier. One possible Option is to use more than one character:

1;@@example "test" text@@;123

Another way to deal with this is to escape the occuring character within the text. Due to the fact that you cannot specifiy the escape string in AX I tried several ways to do the escape. \" is not working. Instead you have to double the character:

1;"example ""test"" text";123

This will Import the text example "test" text into the database.

 

No comments: