Extract Base Metadata Expansion

[hauwi]

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.

[Alexey_Gusev · Accepted solution]

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}

[hauwi]

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?

[Alexey_Gusev]

Sure. Just wrap your whole formula in LOWER( )

[hauwi]

Brilliant! Thank you. 🙏