Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 314 Oracle Analytics and AI News
- 58 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 119 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI 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
Anjana J
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