Editing Multiple Rows of Data with (Ctrl F)

[Orangeworker]

Hi,

I need to edit many rows of text that I have listed in a table -- like in the example listed below. Is it possible to make the edits all at once with (Ctrl F) ?

By Your Side O-0427
By Your Side O-0427_Instrumental



NEEDS TO LOOK LIKE

By Your Side
By Your Side_Instrumental

Thanks

[ajetrumpet]

you need to find the patterns. use the find and replace if you have to. update queries work too.

[Orangeworker]

I figured it out with Find/Replace

Find: O-*
Replace: _Instrumental


then I did


Find: _Instrumental
Replace: _Instrumental


That worked!