topic Re: Data quality in QlikView

Data quality

Anonymous — Fri, 22 Sep 2017 13:02:02 GMT

Hi All,

i have a column called name. it contain "firstname midname lastname".

Problem is that spaces between "firstname midname lastname" is not even. e.g. first (two spaces) mindname (one space)lastname.

how to make the spaces even(only one space between "firstname midname lastname")

Re: Data quality

sunny_talwar — Fri, 22 Sep 2017 13:15:28 GMT

May be this

Replace(name, ' ', ' ') as name

Re: Data quality

Anonymous — Fri, 22 Sep 2017 13:32:58 GMT

thanks for your reply. already got the same solution

Re: Data quality

Anonymous — Fri, 22 Sep 2017 13:34:02 GMT

Hello - you could also try this.

SubField(Name,' ',1)&' '&SubField(Name,' ',2)

Re: Data quality

vkhassanov — Fri, 22 Sep 2017 13:42:29 GMT

For any number of spaces inside:

Left(name,Index(name,' ')-1) & ' ' & Trim(Mid(name,Index(name,' '),Index(name,' ',-1)-Index(name,' '))) & ' ' & Trim(Right(name,Len(name)-Index(name,' ',-1)))