Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
christophebrault
Valued Contributor

Delete space in data

Hi,

In one of my fields, i have data like 'AAAA  BB CC' or 'AAA BB CCC' and i want them as 'AAABBBCC' and ' AAABBCCC'.

How can i do that ?

1 Solution

Accepted Solutions
fosuzuki
Valued Contributor II

Delete space in data

Hi, use the Replace() Function, like:

replace(field, ' ', '').

Hope this helps you.

Regards,

Fernando

2 Replies
fosuzuki
Valued Contributor II

Delete space in data

Hi, use the Replace() Function, like:

replace(field, ' ', '').

Hope this helps you.

Regards,

Fernando

MVP
MVP

Delete space in data

Hi,

Use this

=PurgeChar( ColumnName , ' ' )

Regards,

Jagan.

Community Browser