topic Re: How to remove enters in fields in QlikView

How to remove enters in fields

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

I have a field in excel as below.

'Safety and security features

(e.g. seatbelts, ABS, airbags, immobilizer, parking sensor, etc.)'

I want to remove enters while loading in qlikview...output should be

'Safety and security features (e.g. seatbelts, ABS, airbags, immmobilizer, parking sensor, etc.)'

how can it be done...

varshavig12 — Thu, 10 Nov 2016 06:14:04 GMT

=PurgeChar(FieldName,chr(10))

Anil_Babu_Samineni — Thu, 10 Nov 2016 06:18:08 GMT

Confusing, Would you elaborate more. You have row level values. Can you explain Values again with Dum Data

Anonymous — Thu, 10 Nov 2016 06:32:11 GMT

there is a enter after 'features' I want a backspace so that output could be

Safety and security features (e.g. seatbelts, ABS, airbags, immmobilizer, parking sensor, etc.)' while loading in qlikview

MindaugasBacius — Thu, 10 Nov 2016 06:45:08 GMT

LOAD Replace(A, Chr(10), ' ') as A

FROM

(ooxml, explicit labels, table is Sheet1);

The result: