Help

Extract only the 2nd character, using LEFT function (or similar)

Topic Labels: Formulas
Solved
Jump to Solution
332 4
cancel
Showing results for 
Search instead for 
Did you mean: 
hauwi
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

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}

See Solution in Thread

4 Replies 4
Alexey_Gusev
12 - Earth
12 - Earth

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
6 - Interface Innovator
6 - Interface Innovator

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( )

hauwi
6 - Interface Innovator
6 - Interface Innovator

Brilliant! Thank you. 🙏