Como quitar rango de caracteres?

[#1]

Tengo un problema, tengo los siguientes terminos de esta manera.

2B CARRO1

3B CARRO 1

6T CARRO 2

CARRO 3 8B

CARRO 4 9B

CARRO5 8C

Quiero quitar el rango de caracter que dice carro y su secuencia, para que quede asi.

2B

3B

6T

8B

9B

8C

Ayuda

[#2]

This isn't foolproof, since it only works if the string is in the first two positions or in the last two positions. Maybe a start though.

[MayilVahanan]

Hi

you can also try like this

Load *

if(len(SubField(DATA,' ',1)) =  2, SubField(DATA,' ',1),SubField(DATA,' ',-1)) as FieldName

from tablename;

Hope it helps