Skip to Content
0
Former Member
Oct 11, 2014 at 06:24 PM

how to convert phone number to specific format

341 Views

HI i am new to sap BW and i am trying to load master data with tranformation rule to convert phone number.

my input phone number is 1234567890

i need to write a transformation formula to convert it to (123)-456-7890

please help me how to do it.

Thanks

Kiran