Positive Pay Files
if: statement not producing expected results
|
Trish Posts: 2
3/29/2012
|
Thanks! That worked.
|
|
|
0
link
|
|
Brian Administrator Posts: 24
3/29/2012
|
BrianAdministrator Posts: 24
Trish -
It would probably be best in this situation to do the conditional processing in the form itself rather than attempt to do it inline with the Positive Pay spec.
You could create an intermediate variable of sorts, which we'll call "Recipient" for the purpose of this discussion, and conditionally assign it to the contents of one of the two fields.
For instance, in the Footer Objects, you could do this:
#If [Empty, {SubStr: "{DocRecip}", 2, 1}]
#Assign Recipient, {PayeeAds1}
#Else
#Assign Recipient, {DocRecip}
Then, in the Positive Pay file, you could simply output the value of Recipient as normal without having to deal with any complicated syntax.
--
Wellspring Software
Support Technician
|
|
|
0
link
|
|
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
|