Query Question...

  • Thread starter Thread starter 116
  • Start date Start date
1

116

I have filenames listed in a DB with '.pdf', I would like to to run an update
query to loose the '.pdf' since everything is scanned as a pdf. There are
hundreds of entries. Can someone give me a hand with the script?

Thanks
David
 
In an update query AFTER BACKING UP DATABASE use this --
Replace([YourField], ".pdf", "")
 
I have filenames listed in a DB with '.pdf', I would like to to run an update
query to loose the '.pdf' since everything is scanned as a pdf. There are
hundreds of entries. Can someone give me a hand with the script?

Thanks
David
Click to expand...

No "script" is needed; instead use an Update Query.

Create a query based on the table; select the filename field. Use a criterion
on the field of

LIKE "*.pdf"

to select only those records which need editing (it might be all records, but
be safe!)

Change the query to an Update query and update the field to

Left([your field name here], Len([your field name here]) - 4)

to trim off the last four characters.
 
Back
Top