Pulling a character from a cell

[jlfromm]

I have a file that have 4 letter in a cell and I want to just pull the 3 letter out and put in it a new cell. How would I write that formula

Example 

ID

HSDY

New ID

D

[alexnajm]

What is the expected output for the below data?

[kamal03]

Hi @jlfromm ,

You can achieve this by using a left function in the formula tool.

Please try this formula to get the desired output.

Left([Column], 3)

[jlfromm]

in the new column I just want the third character

So if the Cell is showing HSDY I want new coulmn to show D

[alexnajm · Accepted solution]

Got it - this formula should work then! Substring([Field],2,1)

However what if there is no third character?

[kamal03 · Accepted solution]

Hi @jlfromm 

In this case , you can use substring formula to get the output.

if Length([Column])>3
then
substring([Column],2,1)
else [Column]

endif