Informatica number formatting

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

Questions by suchipriya

Showing Answers 1 - 5 of 5 Answers


  • Sep 28th, 2011

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

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


  • Dec 4th, 2011

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

  Was this answer useful?  Yes


  • 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