Someone asked this question on Oracle BI publisher forum and i just wondered whether it is possible with any formatting XSL function or not. I tried with format-number function but finally i got with extended XSL functions for use in RTF template
Case:
Let's say we have xml data in below format
1234567890
Now we want to display it as (123)456-7890 (US style Ph #)
Solution:
<?xdofx:’(‘||substr(Phone_No,1,3)||’) ’||substr(Phone_No,4,3)||’-‘||substr(Phone_No,7,4)?>
Case:
Let's say we have xml data in below format
Now we want to display it as (123)456-7890 (US style Ph #)
Solution:
<?xdofx:’(‘||substr(Phone_No,1,3)||’) ’||substr(Phone_No,4,3)||’-‘||substr(Phone_No,7,4)?>
hello,
ReplyDeleteI want to format a number like this format (123 456 254 214,410)
: space for thoussand separator and ',' for decimal separator using XML Publisher.
Can u tell me how to do that.
Thanks.
THANK YOU, THANK YOU, THANK YOU! I've looked everywhere for this format and couldn't find anything helpful!
ReplyDeleteThanks a lot for writing this blog.
ReplyDeleteIt solved my prob:-)
Excellent.. me too looked for many places.. but here only I got luckily..Thanks a lot..
ReplyDeleteSSN masking :
ReplyDeletes
ReplyDeletexdofx:substr(NATIONAL_ID,1,3)||’-’||substr(NATIONAL_ID,4,2)||’-‘||substr(NATIONAL_ID,6,4)
ReplyDelete