Skip to main content

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. 🙏


Reply