Set analysis desired field has a ' in it.

[#1]

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.

[#2]

replace(l2hdrtxt,chr(39),'')

I have had the same issue, just not setanalysis.  The above should help get you in the right direction

[#3]

Do you know where I'd put that piece of code, marcsliving?

[erichshiino · Accepted solution]

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