Remove from String Query

[gripper]

Hi board members,

I am hoping to get some assistance on an issue with a field in a table of mine.

I have a table "keyword" within that table there are about 10 fields. One of my fields has a file name in it (example: Vehicles_1_trains.csv) These records were all imported and the file name they came from was placed in this field. Now I wish to remove all the ".csv" reference on all my records from within this "FileName" field making sure to leave everything else in tack.

Here is my thought process
1. I will make a back up copy of the table first
2. Then run some type of update query on that field.

I need help with the second part.

What would the syntax be to remove ".csv" from every record in that field.

Thank you for you help.

 

[S M C]

You don't necessarily need a syntax to replace all those extensions.

Hit CTRL+H, and in the window, and replace .csv with blank. ensure you select the concerned field name in the list below, and also to match any part of the field.

If you are looking for an SQL query to do this, revert.

 

[gripper]

That works. I don't know what I was thinking of. I guess I was making it too complicated.

Thank for the help