top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Finding special character using Informatica Expression transformation?

+1 vote
1,229 views

I have an xml file my tag is like

<'mytag'>'data'<'/mytag'>

I need to find position of <'/mytag'> using Informatica Expression transformation. How can I achieve that?

posted Jul 1, 2014 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

INSTR(INPUT_PORT,'<'||chr(39)||'/mytag'||chr(39)||'>')
answer Jul 1, 2014 by Shweta Singh
Hi Shweta,

Why chr(39) is used to achieve about. pls specify more on that.


would like to know in detail
commented Jul 28, 2015 by anonymous
Similar Questions
0 votes
while loading data from Teradata to Oracle using informatica powercenter, we are facing special character issue

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

+1 vote
Formatting a column using Expression Transformation in Informatica Powercenter

I have a Column (SALARY) in Source Table from Relational DB, for example 15000 is a record in SALARY column and I want to format it as $15,000.00 into the Target table which is a Relational DB using Expression Transformation.

Thankyou

+1 vote
How to convert string into number using expression transformation in informatica?

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

how can i get this same data with '$' symbol in target by using expression transformation in informatica?

anyone help me please, thanks in advance.

+2 votes
How to convert string into number using expression transformation in informatica?

I have source column(amount) with datatype string, contains the datas like $793.00, $5791.00,...

I need to load this same data into the target table column(amount) with datatype NUMBER

How can i get this same data with '$' symbol in target by using expression transformation in informatica?

...