Extract data without delimiters

[nfernandez3]

Hi Community. 

I'm trying to extract data from 1 column which contains alphanumeric values with two different length (8 and 9). 

Could you please helpme with that. 

Many Thanks. 

[Prometheus]

@nfernandez3 What are you trying to get out of this column? Are you trying to get less characters than are present or?

[nfernandez3]

If length is 9, i need to extract 8 values from left to right or

If length is 8, i requires to extract 7 values from left to right   

Both results in one column. 

Thanks in advance!

[Prometheus · Accepted solution]

@nfernandez3 You can use the Formula tool to create a single column using this expression: 

if Length([ID])=9

then Left([ID], 8)

elseif Length([ID])=8

then Left([ID], 7)

else null()

endif

 

[OllieClarke]

Hi @nfernandez3 you could also use the left() and Length() function combined like:

LEFT([Field],Length([Field])-1)

Hope that helps,

Ollie

[nfernandez3]

Excellent ! It works. 

Thank you so much for your quick response!