Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm doing set analysis and my fields desired value has a ' in it. What can I do.
Problem:
l2hdrtxt={'SHAREHOLDERS' EQUITY'}
since there is a ' within the ' '. It messes up the expresion.
On set analysis, you could try this:
l2hdrtxt={"SHAREHOLDERS' EQUITY"}
or create an auxiliary field on your script:
Table:
Load replace(l2hdrtxt,chr(39),'') as fix_l2hdrtxt, l2hdrtxt ...
Then, on set analysis: fix_l2hdrtxt={"SHAREHOLDERS EQUITY"}
Hope this helps,
Erich
replace(l2hdrtxt,chr(39),'')
I have had the same issue, just not setanalysis. The above should help get you in the right direction
Do you know where I'd put that piece of code, marcsliving?
On set analysis, you could try this:
l2hdrtxt={"SHAREHOLDERS' EQUITY"}
or create an auxiliary field on your script:
Table:
Load replace(l2hdrtxt,chr(39),'') as fix_l2hdrtxt, l2hdrtxt ...
Then, on set analysis: fix_l2hdrtxt={"SHAREHOLDERS EQUITY"}
Hope this helps,
Erich