How can I load only the letter characters of a field?

[#1]

Hello,

I just started working with QlikView, and i trying to load a table from internet, but this table contains a field with letters and numbers:

        and the load results in this:

How can I load just the names, whithout the numbers?

Here is my script:

LOAD   classificação1 as time

FROM

[blabla.com]

(html, utf8, embedded labels, table is @1);

Thanks!

[#2]

Ola Rafael,

You can use the space as a delimiter. Like this:

LOAD   left(classificação1,findoneof(classificação1,' ')) as time

FROM

[blabla.com]

(html, utf8, embedded labels, table is @1);     

Espero que ajude.

Cumprimentos,

Nuno

[#3]

It worked!

thanks Nuno!!!

[felipe_dutra]

Rafael, tente isto:

Subfield(classificação1, ' ', 1) as time

Abs

Felipe

[#5]

Felipe

It worked,

thanks!

[#6 · Accepted solution]

Just now I notice that your solutions doesn't work when the string have 2 blank spaces, like in "São Paulo 1".

So, i combined both ideas in a IF statement to verify the number of blank spaces at string, and replace the correct position with a empty character:

LOAD

  IF(not(IsNull(SubField(classificação1,' ',3))), replace(classificação1,SubField(classificação1,' ',3),''), replace(classificação1,SubField(classificação1,' ',2),'')) as time

FROM

[blabla.com]

(html, utf8, embedded labels, table is @1);

Thanks for all the help!!!

[felipe_dutra]

Left(classificação1, Len(classificação1)-Len(Subfield(classificação1, ' ', -1))-1) as time