Discussion Board for collaboration related to QlikView App Development.
I want to remove the spaces in middle of the field values.
I am attaching the sample excel file and Application
MAPPING LOAD repeat(' ', RecNo()), ' '
Description as Description1,
MapSubString('SpaceMap', trim(Description)) as Description
(ooxml, embedded labels, table is Sheet1);
If you want to reduce multiple consecutive spaces between words and have only a single space you could:
Replace(Description, Repeat( Chr(32) , 2 ) ,'')
or if you want to remove spaces entirely:
PurgeChar( Description , ' ' )