I found this thread thread690-1770684
which says to use "" to clear any existing data on the fields when importing.
This works fine if typed manually on the import screen, but I have hundreds of blanks in various columns I want to clear so I need it to remember the " from the csv file.
I have tried various ways and it seems that no matter how many " I add in they are all simply ignored when the import screen pulls it in.
I assume there is a break character I can use, but I cant find any mention of that anywhere.
which says to use "" to clear any existing data on the fields when importing.
This works fine if typed manually on the import screen, but I have hundreds of blanks in various columns I want to clear so I need it to remember the " from the csv file.
I have tried various ways and it seems that no matter how many " I add in they are all simply ignored when the import screen pulls it in.
I assume there is a break character I can use, but I cant find any mention of that anywhere.