Custom Functions in SaasAnt Transactions (Desktop):
SaasAnt Transactions (Desktop) comes with a suite of predefined customized functions or formulas to ease file processing.
Following custom functions are available.
- Set Value if Empty
- Override
- Replace If Matches
- Skip If Matches
- Skip If Contains
- Merge
- Expression
| S.No | Function | Details |
|---|---|---|
| 1 | Set Value if Empty | Update the field with the given value if the corresponding cell is EMPTY Example: File Value : Custom Function Value 1: Customer 1 Final File Value: Customer 1 |
| 2 | Override | Update the field with the given value. It will replace the content in the file. Example: File Value : Jn-1 Custom Function Value 1: John Final File Value : John |
| 3 | Replace If Matches | Replace the content with given value. Example: File Value : Inv-1000 Custom Function Value 1: Inv Custom Function Value 2: INVOICE Final File Value : INVOICE-1000 |
| 4 | Skip If Matches | Skip the entire line if the given value matches with mapped field Example: File Value : Test Custom Function Value 1: Test Final File Value : Line will be skipped for import |
| 5 | Skip If Contains | Skip the entire line if mapped field contains the given value ( partial match) Example: File Value : Test Transaction Ignore Custom Function Value 1: Test Final File Value : Line will be skipped for import |
| 6 | Merge | Merge Multiple values available in the file Example: File Value Column 1 : John File Value Column 2: St Custom Function Value 1: Column 1,Column 2 Final File Value : John St |
| 7 | Expression | Populate the file value in the given template expression ({} will be replaced by file data) Example: File Value : John Custom Function Value 1: Thank You {} Final File Value : Thank You John |