I'm a beginner and I'm trying to concatenate and get the left 3 characters of two fields.
First Name: John
Last Name: Smith
Create a calc field (result type TEXT) like this:
Lower ( Left( Last Name; 3 ) & Left (First Name ; 3 ))
if you want to handle very short names also in 6 characters it should be sth. like:
Lower ( Left( Last Name & "___"; 3 ) & Left (First Name & "___" ; 3 ))
Thank you. That worked. I'm not sure how the lower function works but I'll look into it.
lower("aAbBcCdD") -> "aabbccdd"
FileMaker Pro 16 Help
Lower case. That makes sense. Thanks again!
Retrieving data ...