R12.1.3 - Supplier Payment file - eText file

Ajakkam

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

Brajesh Shukla-95078

I tried this...worked for me...could you please upload your rtf?

Brajesh Shukla-95078

You are almost there...could you use below

REPLACE(Payee/Name, '''', '')

Ajakkam

Hi,

I tried with REPLACE(Payee/Name, '''', '') but not working.

Regards,

Anjana

Bruce Wang

try this one:

<?xdoxslt:set_variable($_XDOCTX, 'apt', "'")?>

<?translate(Payee/Name,xdoxslt:get_variable($_XDOCTX,'apt'),'')?>

Ajakkam

Hi,

It is working for me after copy and paste of above syntax.

Thanks a lot

Regards,

Anjana