I Need to get the 3rd digit of this string value Prod Line 12211

[Karl_Spratt]

Hi Folks,

I'm sure it's very simple but I can't figure it out 😞

I Need to get the 3rd digit of this string value Prod Line 12211  

n this case I want 2 as the value, but if the Prod Line was 12104 I'd want the 1 back can anyone please advise how to do this?

Cheers,

Karl

[MarqueeCrew]

@Karl_Spratt ,

substring([text field],2,1)

if that # is an integer, you will either need to select it and change it to V_String or nest it with ToString([Number field])

substring(ToString([number]),2,1)

 cheers,

 mark

[Karl_Spratt]

Hi Mark,

Sorry I wasn't clear, what I need is the 3rd character from this column, the column is a v_string format column, the values in the 3rd space I need to pull back please. (So in this case the value is 2) but it might be a 5, a 7 a 9 in the 3rd space so I need to pull based on the location in the string.

Can you please assist, how would you write that formula.   Cheers Karl,

[MarqueeCrew · Accepted solution]

Did you try my first formula?