topic Re: Multiple spaces in field in QlikView

Multiple spaces in field

bramvdpoel — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can i reduce multiple spaces in a field in the loading script?

Field value from the data is: 165/70TR13 APLUS TL A606 (NEU) 79T *E*

I would like it to be: 165/70TR13 APLUS TL A606 (NEU) 79T *E*

Directory;
LOAD [VDB Articlenr.] as VDBArtikel,
[EAN code] as EAN,
Brand as Merk,
Measurecode as Maat,
Vehicle,
Season,
num([KB price]) as BrutovdBan,
num([Netto Price]) as Netto,
num([Netto Price])*2 as BrutoDubbel,
[Article description] as Omschrijving,
Upper(Brand & Season) as Match
FROM
[..\..\Temp\266032_1.csv]

Re: Multiple spaces in field

OmarBenSalem — Thu, 13 Dec 2018 13:41:47 GMT

try :

replace(Field,' ',' ')

Re: Multiple spaces in field

bramvdpoel — Thu, 13 Dec 2018 13:56:47 GMT

Doesn't work, then double spaces become a single space. When there are 10 double spaces it converts into 5 single spaces.

Re: Multiple spaces in field

Anil_Babu_Samineni — Thu, 13 Dec 2018 13:57:42 GMT

I am assuming that field value from VDBArtikel. Try the attachment using Mapping table. You can reload using the correct path

Re: Multiple spaces in field

sunny_talwar — Thu, 13 Dec 2018 14:04:51 GMT

One way could be to use something like this

Table:
LOAD Concat(Field, ' ', Num) as Field;
LOAD Field,
	 RecNo() as Num
Where Len(Trim(Field)) > 0;
LOAD SubField(Field, ' ') as Field;
LOAD * INLINE [
    Field
    165/70TR13  APLUS TL A606                      (NEU) 79T *E*
];

Re: Multiple spaces in field

Colin-Albert — Thu, 13 Dec 2018 14:51:33 GMT

You can nest multiple replace statements so if the result of the first replace is two spaces, they are replaced again.

replace(replace(replace(replace(replace(Field,' ',' ') ,' ',' ') ,' ',' ') ,' ',' ') ,' ',' ')