Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Please refere below data sample -
id
230
123
455
555
645
222
i only want those data that i have no space so which function i have to used in script level.
my expected output is
id
230
455
645
222
Thanks in advance
Set Verbatim = 1;
LOAD id
From YourSource
Where Len(Trim(id)) = Len(id);
regards
Marco
hi MarcoWedel,
please explain me what does exactly the Variable !!... Verbatim do?
-Hirish
From QlikView's help (QlikView ‒ Verbatim)
HI friends,
Thank u for your quik reply,
i used if() and len() function in my script i got solution of my problem.
please refer below attached extractor
Hi Khutal,
in case if we have 4 digit number in ID column like 9999..... ,then how it will work?
Hi you can you trim() function also.
Hi Ananth,
In my case i have only 3 digit data and i want only those 3 digit data those data have not a space that i mention in my expected answer.
Hi Rajesh,
I have also used Trim() function but i didn't got my expecated answer.
Thanks to both of you.
Hi Ishwar,
try the following instruction in your script.
...
LOAD
if(isnum(replace(id,' ','A')),id ) as id
FROM
...
best regards
Andrea