How to remove space in column in qlik sense

[Sai_Mohan]

Hi Team,

I am new to Qlik Sense. I have a field named 'Ref number' . In that field, there are few values , in which "Space" is also one of the value. I have to remove that space and i need to show values(only numbers) in it .

Note:  I have also unchecked that include null values.

For example:

• currently it is giving values like: '12', '13','14', '15', '  ', '12', '  ', '  ' , '123' ... Please consider those values like each row has one of the value.

Please help me with this asap

Thanks.

[jwjackso · Accepted solution]

A simple method in the data load script:

Data:
load *
where Len(Trim(Value)) > 0;
load * Inline [
Value
'12'
'13'
'14'
'15'
' '
'12'
' '
' '
'123'
];

[Sai_Mohan]

Thanks For Replying!

But in my scenario, I am having those values in a table, which is a excel file.

For example: In a table, my column name is ref_num and values in that is number and space. 

If there is null values i can remove it easily, but it is like space. 

Id	Ref_num
1	5443
2	5464
3
4	5464
5
6	4566
7	3435
8
9	6555
10	4344

How to remove the space value(3,5,8) from that column ?

Thanks 

[tresesco · Accepted solution]

Try like:

Load  *  from  <>  Where Len(Trim(Ref_num))>0; 

[Sai_Mohan]

Thanks!!

It is working.