Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
R12.1.3 - Supplier Payment file - eText file
Ajakkam
Rank 2 - Community Beginner
Summary
R12.1.3 - Supplier Payment file - eText file
Content
Hi,
I am building Supplier payment file as eText output in RTF template.
I want to remove apostrophe (') in supplier name in eText output file. I have used REPLACE function (i.e: REPLACE(Payee/Name,'''',''))but it is not working.
Regards,
Anjana
0
Answers
-
I tried this...worked for me...could you please upload your rtf?
0 -
You are almost there...could you use below
REPLACE(Payee/Name, '''', '')
0 -
Hi,
I tried with REPLACE(Payee/Name, '''', '') but not working.
Regards,
Anjana
0 -
try this one:
<?xdoxslt:set_variable($_XDOCTX, 'apt', "'")?>
<?translate(Payee/Name,xdoxslt:get_variable($_XDOCTX,'apt'),'')?>
0 -
Hi,
It is working for me after copy and paste of above syntax.
Thanks a lot
Regards,
Anjana
0