In the previous section, we talked about Date calculation. In this section, we will learn about String calculations.
A lot of times we need to get the last name out of an email. A simple String calculation will do the work.
For example, if I want to get last name from an email address like firstName.firstname.lastname@example.org. The calculation is as follows:
You can get the string on the left of the "@" using the LEFT function. The next step is to use the MID function to get the string from the period to the left of the "@".
For example, I want to get the street number from ...