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
Résolu ! Accéder à la solution.
What is the expected output for the below data?
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)
in the new column I just want the third character
So if the Cell is showing HSDY I want new coulmn to show D
Got it - this formula should work then! Substring([Field],2,1)
However what if there is no third character?
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