Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
TKendrick20
Partner - Specialist
Partner - Specialist

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

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

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Partner - Specialist
Partner - Specialist
Author

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