Shunt address data left

  • Thread starter Thread starter Garry
  • Start date Start date
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
 
Try opening your CSV file with Word and replace all two comma combinations
with one comma. Save as a different name and then import.
 
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.
 
Back
Top