Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!!!
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
It worked!
thanks Nuno!!!
Rafael, tente isto:
Subfield(classificação1, ' ', 1) as time
Abs
Felipe
Felipe
It worked,
thanks!
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!!!
Left(classificação1, Len(classificação1)-Len(Subfield(classificação1, ' ', -1))-1) as time