QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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

{XXXXX-XX-XXXX-XXX}|20130712

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

Tags (5)
1 Solution

Accepted Solutions
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
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
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.

Community Browser