[GIS] Find and replace single word in string using QGIS Field Calculator

field-calculatorfindqgis

How do I find and replace a single word of a string?

e.g.
Calle Iparraguirre to Iparraguirre

I've tried:

replace( 'Calle\\s', 'Calle\\s', '')

replace( "name",'calle','')

and all combinations of code, but nothing is working :/

*I've read other Q&A's but no result

Best Answer

As stated in the function help, the correct syntax is

replace('QGIS SHOULD ROCK','SHOULD','DOES') → 'QGIS DOES ROCK'

Note that the function is case senstive so Calle != calle