Find and replace data in a field <SOLVED>

[LSemmens]

For some reason I somehow changed an image field from using relative addressing to absolute addresses (I suspect that it might have been during some OS change a while back.) Anyway, I now have several hundred records with a field SM_IMAGE in the format

/home/leigh/Desktop/Australia/2130-2133MS.jpg

I need to change those records to the format below

MyImages/Australia/2130-2133MS.jpg

I’m guessing an SQL statement might be needed but I am unsure of the process.

The table name is called MASTER and the Field is called SM_IMAGE

Obviously I need to preserve the file name referred to.

[RobertG]

Something like this would work:

UPDATE "MASTER" SET "SM_IMAGE" = REPLACE("SM_IMAGE",'/home/leigh/Desktop/','MyImages/')

Works with internal HSQLDB and internal Firebird database engine.

[LSemmens]

Thanks for that, I’ve not had time to try it yet. Maybe this evening.

[LSemmens]

@RobertG

UPDATE "MASTER" SET "SM_IMAGE" = REPLACE("SM_IMAGE",'/home/leigh/Desktop/','MyImages/'

Finally got back to this, thank you, that did solve my issue!

[fpy]

find & replace tool in LibreOffice Base

Is there replace option in Base? Simply I need some repeating text (letter) in the field (column) to replace with another, so how to do that? Thank you.