Summary

Replace Dollar Symbol with blank from Amount String Ex: $******250.56

Content

Hi,

I am trying to replace $ symbol in amount string with blank. The amount is being displayed in AP cheque portion.

Can someone tell me how to resolve this.

1. Here is the XML tag. you can find this in the XML file. Partial data is given below.

<Payment_Amount_String___Local_ID42>$*******250.56</Payment_Amount_String___Local_ID42>

2. I have the below syntax to display amount with ifelse condition and amount is displaying as $********250.56

<?xdoxslt:ifelse(Current_stub_number___Local_ID46<Stub_Total___Local_ID66,'00000000000000’,Payment_Amount_String___Local_ID42)?>

3.From the above output $*******250.56 I need to replace $ with blank.

If I use only this syntax <?xdofx:replace(Payment_Amount_String___Local_ID42,'$','')?> it is displaying fine as ******250.56

I need to embed the above replace syntax in the second point ifelse syntax statement,

4. I tried to arrange syntax as below. But it did not work value is displayed a '$',)?>

<?xdoxslt:ifelse(Current_stub_number___Local_ID46<Stub_Total___Local_ID66,'00000000000000’,<?xdofx:replace(Payment_Amount_String___Local_ID42,'$','')?>)?>

Let me know if need anymore information.

******************************************************************************************************

<Payment_Selection_S7>

<Payee_Address_Number__PO__ID99>100035</Payee_Address_Number__PO__ID99>

<Payee__ID88>Payee:</Payee__ID88>

<BankTransitNumber_ID121>Bank Transit</BankTransitNumber_ID121>

<Payment_Item_String___Local_ID41>00010004</Payment_Item_String___Local_ID41>

<CustBankAcctNumber_ID123>Customer Bank Acct #</CustBankAcctNumber_ID123>

<Payment_Amount_String___Local_ID42>$*******250.56</Payment_Amount_String___Local_ID42>

<G_L_Date___Local_ID18>2017-04-24</G_L_Date___Local_ID18>

<Supplier_Number_ID116>100035</Supplier_Number_ID116>

<Description___Local_ID20>TWO HUNDRED FIFTY AND 56/100*********************************************************</Description___Local_ID20>

<Mailing_Name___Local_ID33>Bishop and McKenzie LLP</Mailing_Name___Local_ID33>

</Payment_Selection_S7>

******************************************************************************************************

Thanks,

Vijay Vattiprolu