Hi, I would like to extract only the 2nd character of a data field, to concatenate with another complete data field.
Can this be done please? Many thanks.
Solved
Extract only the 2nd character, using LEFT function (or similar)
+10Best answer by Alexey_Gusev
Hi,
MID({Data}, 2, 1) or RIGHT(LEFT({Data},2))
some array data types like Lookup field, require converting to string like CONCATENATE({Data}) instead of {Data}
+25Hi,
MID({Data}, 2, 1) or RIGHT(LEFT({Data},2))
some array data types like Lookup field, require converting to string like CONCATENATE({Data}) instead of {Data}
+10Fantastic. That works perfectly, thank you.
Follow-up Q if I may: Is it possible to force it to return only that character in lower-case?
+25Fantastic. That works perfectly, thank you.
Follow-up Q if I may: Is it possible to force it to return only that character in lower-case?
Sure. Just wrap your whole formula in LOWER( )
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.