Hi,
I have a variable from a SQL DataBase, with special characters, like 'return' or 'tab'. But I can not display they ok.
I look for de char(10), delete it and put '\'
It works with 'return' character. But I don't know what to do with the tab character.
I look for de char(9), delete it, but I don't know the sustitute to show it correctly.
This is part of my code:
//Return character
LF := 10;
intPos := STRPOS(txtmensaje,FORMAT(LF));
WHILE intPos > 0
DO BEGIN
txtmensaje := DELSTR(txtmensaje,intPos,1);
txtmensaje := INSSTR(txtmensaje,'\',intPos);
intPos := STRPOS(txtmensaje,FORMAT(LF));
END;
//Tab character
HT := 9;
intPos := STRPOS(txtmensaje,FORMAT(HT));
WHILE intPos > 0
DO BEGIN
txtmensaje := DELSTR(txtmensaje,intPos,1);
txtmensaje := INSSTR(txtmensaje,' ? ',intPos);
intPos := STRPOS(txtmensaje,FORMAT(HT));
END;
Thank you.
0
Comments
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Create text variable.Press TAB in Notepad.Copy it and paste it in Navision where you are setting the variable between the comas.
TabVar:=' ';
//After that u can use
convertstr(txtmensaje,TabVar,'\');