Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

TKendrick20
Not applicable

Getting rid of curly brackets around loaded data

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Getting rid of curly brackets around loaded data

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

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

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


talk is cheap, supply exceeds demand
2 Replies
Gysbert_Wassenaar
Not applicable

Re: Getting rid of curly brackets around loaded data

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

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

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


talk is cheap, supply exceeds demand
TKendrick20
Not applicable

Re: Getting rid of curly brackets around loaded data

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