Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
bramvdpoel
Contributor III
Contributor III

Multiple spaces in field

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]

1 Solution

Accepted Solutions
Colin-Albert

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,'  ',' ') ,'  ',' ') ,'  ',' ') ,'  ',' ') ,'  ',' ') 

View solution in original post

5 Replies
OmarBenSalem

try : 

replace(Field,'  ',' ') 

bramvdpoel
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

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*
];
Colin-Albert

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,'  ',' ') ,'  ',' ') ,'  ',' ') ,'  ',' ') ,'  ',' ')