Positive Pay Files
if: statement not producing expected results
|
Trish Posts: 2
3/27/2012
|
I'm creating a positive pay file using version 5.39.7
I need to use a condition check to determine which field should go into the file.
The following statement seems to produce the correct result for the true condition but for the false condition I am getting two fields put in the file - a constant '{PayeeAds1' followed by the value of DocRecip in single quotes followed by }
Statement:
"{if:Empty{TrimAll:'SubStr:'{DocRecip}','2',1'},'{PayeeAds1}','{DocRecip}'}" | Payee Name - if 2nd character of DocRecip is blank, use PayeeAds1, else use DocRecip
Results When True:
FRED FLINTSTONE
Results When False:
{PayeedAds1','Barney Rubble'}
Help or examples would be appreciated.
Thanks!
|
|
|
0
link
|