How to capture whithout space data.

[#1]

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

[MarcoWedel]

Set Verbatim = 1;

LOAD id
From YourSource
Where Len(Trim(id)) = Len(id);

regards

Marco

[HirisH_V7]

hi MarcoWedel‌,

please explain me what does exactly the Variable !!... Verbatim do?

-Hirish

[sunny_talwar]

From QlikView's help (QlikView ‒ Verbatim)

[#5 · Accepted solution]

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

[anat]

Hi Khutal,

in case if we have 4 digit number in ID column like 9999..... ,then how it will work?

[rajeshforqlikvi]

Hi you can you trim() function also.

[#8]

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.

[anlonghi2]

Hi Ishwar,

try the following instruction in your script.

...

LOAD

if(isnum(replace(id,' ','A')),id ) as id

FROM

...

best regards

Andrea