BI publisher: EText Condition Fails with Slanted Apostrophe in XML Tags

Summary:

I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in XML input data.

Content:

My XML tag contains a name value with a slanted apostrophe:

<Name>Children’s Hospital</Name>

My EText logic is:

IF Name = 'Children''s Hospital' 

THEN 'code'

ELSE 'test'

END IF

• The EText condition only works when the apostrophe is replaced with a straight single quote (').

• However, the XML source uses the slanted (typographic) apostrophe and cannot be changed.

• As a result, the condition always goes to ‘test’ instead of ‘code’.