topic Re: Getting rid of curly brackets around loaded data in QlikView

Getting rid of curly brackets around loaded data

TKendrick20 — Fri, 12 Jul 2013 14:39:56 GMT

I'm loading data from a SSMS database and I can't seem to get rid of these curly brackets around the data { }

Here is a sample

trim

([person_id])&'|'&(Date(current_date,'YYYYMMDD') as ProviderKey

Loads as

{XXXXX-XX-XXXX-XXX}|20130712

Why are they there and how do I get rid of them?

Gysbert_Wassenaar — Fri, 12 Jul 2013 14:42:54 GMT

purgechar(person_id, '{}' ) is one option

textbetween(person_id,'{','}') is another

i.e. trim(purgechar([person_id],'{}'))&'|'&(Date(current_date,'YYYYMMDD') as ProviderKey

TKendrick20 — Fri, 12 Jul 2013 14:50:18 GMT

Great, thank you. I was just confused because those brackets do not exist in the data that I am pulling from the SQL table.