Formating Post Import

  • Thread starter Thread starter NeonSky via AccessMonster.com
  • Start date Start date
N

NeonSky via AccessMonster.com

Good Morning,

Hope everyone had a pleasant holiday weekend.

Would someone please explain to me how to delete all instances of a quotation
mark across all fields in a table?

Thanks!
 
Depending on which version of Access you are using, take a look at the
Replace() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Good Morning,

Hope everyone had a pleasant holiday weekend.

Would someone please explain to me how to delete all instances of a quotation
mark across all fields in a table?

Thanks!
Click to expand...

You'll need to run an Update query updating each such field to

Replace([fieldname], """", "")

This will replace all instances of the doublequote character " with a null
string.

Of course not all fields should be affected - only Text datatype fields *can*
contain a quote character.

It would be best to prevent the records from being imported with quotes in the
first place - how are you doing the import? Could you Link to the data source,
and base an append query (trimming the quotemarks as above) on that linked
table?

John W. Vinson [MVP]
 
Hello John,

That worked perfectly, many thanks! Unfortunately at this time the datasource
is unupdateable prior to when we receive it...

MVP Rocks!

Good Morning,
Click to expand...
[quoted text clipped - 4 lines]
Thanks!
Click to expand...

You'll need to run an Update query updating each such field to

Replace([fieldname], """", "")

This will replace all instances of the doublequote character " with a null
string.

Of course not all fields should be affected - only Text datatype fields *can*
contain a quote character.

It would be best to prevent the records from being imported with quotes in the
first place - how are you doing the import? Could you Link to the data source,
and base an append query (trimming the quotemarks as above) on that linked
table?

John W. Vinson [MVP]
Click to expand...
 
Back
Top