Easy to Create, Easy to Change - Easy to use!

Function::String

StringEscape

StringEscape(String) StringEscape("/'This will appear in quotes/'./CR/TBThis will be show on new line and one tab in")

To allow users to include reference to certain "forbidden" characters in a DE string and return the parsed result.

Characters include is: 
" = /'
CR = /CR (New line)
TAB=/TB (Tab)

Tags are case sensitive, so /cr would not be escaped

From 8.6 Onwards you can also use:

" =\/'

CR = \CR (New line)
TAB=\TB (Tab)

Parameters


String: Including codefied "illegal" characters as above.

Returns/Result


String with parsed letters.

Examples


Exanple 1:

Code: StringEscape("/'This will appear in quotes/'./CR/TBThis will be show on new line and one tab in") 

Return:
"This will appear in quotes"
        This will show on new line and one tab in.

Reference

There is an historical problem with including certain characters in DataEase strings, especially in derivations etc. " in particular has been difficult and prior to Version 8.0 there was no good way of building strings or passing strings containing this character in DE. In DE8.0 we got CHR() which made it possible to build strings including " by using CHR(34) and concatenate a string. However this is rather awkward, and particularly when using functions that demand a lot of " etc.

StringEscape() was devised so the developer can parse the entire string in one go without the need of concatenation etc.

However bear in mind that StringEscape() is the fallback function, this functionality has now been included in ALL string functions, so you will now be able to use the switches directly in functions like ExecDQL(), Concat(), SelectionFilter() etc.

See Also


Chr()
ExecDQL()
ConCat()
SelectionFilter()
MemoCopy()
WriteToFile()

On the forum about StringEscape

[@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&nbsp;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 StringEscape