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.
FYI: There is a Formatter > Math > Spreadsheet Style Formula option: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions
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: