CODEWITHSUNDEEP
oracle-databaseinformaticainformatica-powercenter
dev
dev

Reputation: 979

Informatica for special character

I have an xml file my tag is like 

<'vin'>'data'<'/vin'>

I need to find posotion of <'/vin'> using

Informatica Expression transformation

Pleae help.

Upvotes: 1

Views: 789

Answers (1)

Samik
Samik

Reputation: 3455

Use the CHR function with the ASCII code 39 to replace the single quotes like below:

INSTR(INPUT_PORT,'<'||chr(39)||'/vin'||chr(39)||'>')

Upvotes: 1

Related Questions