FR - DE

# Tutorial / # Documentation / # Help

You need more help? You can contact us via this form »

 BACK TO SEARCH
SHARE TO 

Fields functions to extract part of data

Doc. / Help / For version: 7

When you use data fields in different parts like saving email to a folder, or print email with fields, you can now extract only a part of the data. That's usefull when you have long string and want to get only a part.

Example: You want to save email in folder using the email unique id, but it is very long %22456464xcvrg4vcv@sgdcv12%, you want to keep only the last 4 digits so you can use the function: RIGHT(%EMAIL_ID%, 4).

The available functions are:
- LEFT(field,X) = extract the X number of characters from the start (for example LEFT("Order received from King of Flowers", 5) return "Order")

- RIGHT(field,X) = extract the X number of characters from the end (for example RIGHT("Order received from King of Flowers", 7) return "Flowers")

- MID(field,X,Y) = extract the Y number of characters from the X position (for example MID("Order received from King of Flowers", 6, 8) return "received")


extract right part of data

Information: fields, email, extract, right, left, middle, data - Updated the Monday, March 2, 2020