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.
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.
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}
Fantastic. 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?
Fantastic. 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( )
Brilliant! Thank you. 🙏
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.