Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have string variable
let d1 = 'Name1 & ''|'' & Name2'
but when I try do this
$(d1)
get this :
"Syntax error, missing/misplaced"
In MS SQL script is no problem .
Please help me
best regards Vilgis
function relace(string_text_value,'''',''') not working
but replace(string_text_value,'''',chr(39)) working
let d1 = 'Name1 '& '|' & 'Name2';
or
let d1 = Name1 & '|' & Name2;
Names are field;
Thanks Sunil for reply
I just create string by this formula :
TableOfHierarcy:
hierarchy (ID, ParentID, Name, 'ParentName', Name, 'Path', '|', 'Depth')
load
ID,
ParentID,
Nameresident TableOfNodes;
;
LET a = NoOfFields('TableOfHierarcy');
LET b = 1;
Let i = 1;
LET c = '';
LET d = '';
LET d1 = '';
for b = 1 to a-6
for i = 1 to b
c = c & ' Name' & $(i) & ' &'
next
c = left(c,len(c) - 1) & ' as new_name' & $(b) &' ,'
NEXT
d = left(c,len(c)-1);
I want instead symbol '&' replace '&'|"" . But not working
//And d variable is d = '
Name1 as new_name1 , Name1 & Name2 as new_name2 , Name1 & Name2 & Name3 as new_name3
'
function relace(string_text_value,'''',''') not working
but replace(string_text_value,'''',chr(39)) working