Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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

Partner
Partner

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