The Truncate function returns the first letters of a word etc. But we need the last two letters of a string (ZIP-codes) to be returned. I guess we need a spreadsheet-like formula in zapier that returns text. Who can help?
Example: when people submit:
1074XP : we want as a return value: XP
1055 DR: we want as a return value: DR
5678 XX: we want as a return value: XX
Best answer by Troy TessaloneView original
Give this trick a try with the Formatter > Text > Truncate option
TIP: Set the Skip Characters to -2 which will return characters from the end of (right side) of the string.
See example step configured below along with the output.
Excellent. First solution works fine and is sufficient. Thanks! Is there a place where I can find tricks like minus 2 etc.? The help-information of Zapier website is rather elementary.
Best shot at finding tricks/tips is these places:
FYI: There is a Formatter > Math > Spreadsheet Style Formula option: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions