topic Re: changes on string in QlikView

changes on string

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have a country field with all small letters

Now the requirement is change it to only first letter should be in capital letter.

How can we achieve this requirement. I have tried with sub field function but no use.

Any suggestions please help

Thanks in advance!

trdandamudi — Fri, 29 Apr 2016 20:12:33 GMT

May be like this:

capitalize ('london') and it will return 'London'

luizmendes118 — Fri, 29 Apr 2016 20:13:28 GMT

Maybe the function

Capitalize(countryField)

sunny_talwar — Fri, 29 Apr 2016 21:04:02 GMT

What happens if it is two word country name like united states, would you want United States or United states?

If you want United States, then what has been proposed should work like a charm for you -> Capitalize(Country)

If(you wanted United states, then you can try this: Upper(Left(Country, 1)) & Right(Country, Len(Country) - 1)

sunny_talwar — Fri, 29 Apr 2016 21:16:05 GMT

Sample script where I am pulling data from wikipedia

FOR i = 1 to 23

Table:

LOAD Lower(PurgeChar([Country (exonym)], '[]0123456789')) as Country

FROM

(html, codepage is 1252, embedded labels, table is @$(i));

NEXT

FinalTable:

LOAD Country as Lower_Country,

Capitalize(Country) as Capitalized_Country,

Upper(Left(Country, 1)) & Right(Country, Len(Country) - 1) as First_Letter_Capitalized_Country

Resident Table;

DROP Table Table;

Output:

Sat, 30 Apr 2016 02:52:40 GMT

Thanks to everyone for your suggestions.!