quotes in SQL data

[Former Member]

Hello all,

I have implemented a SBO solution with a customer and transeferred all legacy data. However all data in the item masterdata received quotes at the beginning and end of every itemname. For instance, if the DTWB excel template stated : screwdriver, in the itemname SBO shows "screwdriver".

At first I thought it had something to do with the fact that I imported CSV files as semicolon files. But the BP masterdata (which was imported the same way) does not show the quotes.

Has anybody seen this before? Does anyone have a solution?

Thanks in advance!

[Former Member · Accepted solution]

Hi Maarten,

Have you opened the csv files in notepad? Does it actually have quotes around the item descriptions in the notepad (raw) data? If you look at CSV files in Excel it might sometimes be misleading.

Hope it helps,

Adele

[Former Member · Accepted solution]

Hi Adele,

Thanks, did not try that yet and seems to work. Bad news is that I need to reimport 220000 items but at least I have a working solution.

Thanks a lot!!

Best regards,

Maarten