Informatica number formatting

How to format phone number 9999999999 into (999)999-9999 in informatica

Questions by suchipriya

Showing Answers 1 - 1 of 1 Answers

MayankS

  • Sep 28th, 2011
 

Use the expression in Expression Transform.
sample be 9999999999======

' ( ' || SUBSTR(sample,1,3) || ')' ||SUBSTR(sample,4,3) || '-' || SUBSTR(sample,7,4)

sreenu

  • Dec 4th, 2011
 

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

  Was this answer useful?  Yes

Vids

  • Aug 13th, 2013
 

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions