Shunt address data left

G

Garry

Hi all, query solution I hope !

I have imported a csv address file into access : Address1 Address2 -
Address6

Some fields are blank followed by another blank

example : Text Blank Blank Text Text Blank

example : Blank Blank Text Blank Text Blank

example : Text Blank Blank Blank Text Text

How can I shunt all the fields left so as to remove any spaces

cheers, Garry
 
K

KARL DEWEY

Try opening your CSV file with Word and replace all two comma combinations
with one comma. Save as a different name and then import.
 
K

KARL DEWEY

example : Text Blank Blank Blank Text Text
In this case it will only replace the the first set like this --
example : Text Blank Blank Text Text
You will need to do the Replace All several times until it finds no more to
replace.
 
Top