I have a string of text with a coma and need to insert a space

  • Thread starter Thread starter Guest
  • Start date Start date
Is this a name field?

If so, I would highly recommend you stop and normalize your data. Your
first and last names should be stored in separate fields. Then you can
concatenate them and include a comma and a space.
 
Thanks for the replace idea, it worked great. I did not want to have to modiy
over 25,000 records. By the way it was data that I had to import into Access
in the exact format but just needed a space. Could not normalize the input
data.

Thanks again for your assistance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Compare string contents ignoring order 24
Extracting the last word from a string. 2
VLookup and text strings 3
Entering data from a table into a form. 1
simple structure, not so simple 1
how to lookup for a value in a table? 3
Need SUBSTRING like function 3

Back
Top