Replace character in a field

[composti]

Hello,

I want to replace the charakter '*;*' in a database field called "Artikel".

Example:

Field "Artikel" contains the expression "House ; with ; white windows"
and I want to change this to
"House x with x white windows"

Is there a solution for this question?

 

[bulklodd]

FOR EACH <tablename> TRANSACTION:
<tablename>.Artikel = REPLACE(<tablename>.Artikel,";","x").
END.

 

[composti]

Thanks for this quick reply, it works!

 

[cmorgan]

If you want to replace multiple characters with different values, you might also want to take a look at the SUBSTITUTE function.