[TxMt] How can I find and replace carriage returns?

Can someone please tell me how this could be done?

I am having trouble using the "find and replace" command to covert this:

PRODUCTS 2::id DOCUMENTS::id PRODUCTS 2::note PRODUCTS 2::prnt_bleed_lr PRODUCTS 2::prnt_bleed_tb PRODUCTS 2::prnt_gutter_width PRODUCTS 2::prnt_material_width PRODUCTS 2::prnt_max_printable_height PRODUCTS 2::prnt_max_printable_width

to this:

getValue( PRODUCTS 2::id ; 1) ; getValue( DOCUMENTS::id ; 1) ; getValue( PRODUCTS 2::note ; 1) ; getValue( PRODUCTS 2::prnt_bleed_lr ; 1) ; getValue( PRODUCTS 2::prnt_bleed_tb ; 1) ; getValue( PRODUCTS 2::prnt_gutter_width ; 1) ; getValue( PRODUCTS 2::prnt_material_width ; 1) ; getValue( PRODUCTS 2::prnt_max_printable_height ; 1) ; getValue( PRODUCTS 2::prnt_max_printable_width ; 1) ;

I thought that I could simply:

find: \r replace with: ; 1) ; \r getValue(

This does not work. :(