Ph: +1 (619) 377-0977 (9 A.M to 5 P.M EST)

SaasAnt Support Portal

Submit a ticket My Tickets Blog
Welcome
Login  Sign up

Custom Functions in SaasAnt Transactions (Desktop)

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.

  1. Set Value if Empty
  2. Override
  3. Replace If Matches
  4. Skip If Matches
  5. Skip If Contains
  6. Merge
  7. Expression


S.NoFunctionDetails
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
4Skip If MatchesSkip 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
5Skip If ContainsSkip 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
6MergeMerge 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
7ExpressionPopulate 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



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.