Good day Team,
I am using the following formula to do a positive pay file using the CSV data provider, with a GI as the provider of the results:
=[Results.APPayment_extRefNbr]+','+[Results.APPayment_curyOrigDocAmt]+','+Concat('\"'+[Results.Vendor_acctName]+'\"')+','+'99999999999'+','+'A'
the formula is adding quotes to the name of the vendor, under the Export Scenario looks great:
650.7500,"ADP, INC.",99999999999,A
No problem, there, but when we export to the Text File, the file shows the following:
The system keeps adding an initial double quotes and ending double quote as well as doubling the double quotes on the file when we export the data to the file.
I added even the \ on the quotes per several pages I found, but nothing has worked. I really appreciate any help on this.
I reviewed the follwoing link:
but that did not helped, we dont have any spaces on the file.
Thank you.