Function::String
StringReplace 
StringReplace(StringToReplaceIn,StringToReplace,StringToReplaceWith)
StringReplace("This is a test","a test","brilliant!") -- result: This is brilliant.
StringToReplace(MyTextField, ToReplace,ReplaceWith)
retval := StringToReplace(MyTextField, ToReplace,R
To replace all occurrence of a text in a string with another text.
Can be used to replace names, codes, spelling mistakes etc in a text field.
Parameters
StringToReplaceIn:
This is the string that you want to replace text in. "This is a test".
StringToReplace:
This is the string you want to replace. "a test"
StringToReplaceWith:
This is the string you want to change it to: "brilliant!"
Returns/Result
String(255): The complete string with the changes.
Examples
Reference
A useful little function.
If you did a mistake, have changed name, address etc, why not simply find and replace.
Simple find and replace...
text StringRepace(StringToReplaceIn,StringToReplace,StringToReplaceWith)
What more to say, if you don't see the use, you never will..;-)
See Also
MemoReplace()
MemoMemoReplace()
On the forum about StringReplace
[@EOF@]...
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
[@EOF@]...
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Thanks for the very good explanation!AS...
Product: . Written by afonso santos 28/10/19 at 00:50:14
I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
How can i delete a Style sheet?...
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
I run W7 and since a few days Dataease 8.5 is not starting any more, do you have an idea? i installed it again but that did not help....
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
[@EOF@]...
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
On the blog about StringReplace
Register
Sign In
