Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Trimming a string

I have 2 dates taken from different files, and keep getting quotation marks on one of the strings, i cant remove them since the program gets the data like that every update, how do i trim my string to not contain the " since it makes the printed date look like trash.

It currently prints it like "2222-02-22" i want it to print 2222-02-22 but i cant change the data.

1 Solution

Accepted Solutions
arvind_patil
Valued Contributor II

Re: Trimming a string

Hi Linus,

Try this :

Purgechar([DateField],'"') As [New Date]



Thanks,

Arvind Patil

3 Replies
arvind_patil
Valued Contributor II

Re: Trimming a string

Hi Linus,

Try this :

Purgechar([DateField],'"') As [New Date]



Thanks,

Arvind Patil

Not applicable

Re: Trimming a string

Thanks dude works perfectly

arvind_patil
Valued Contributor II

Re: Trimming a string

Hi Linus,

Please mark it as a correct ans.

Thanks,

Arvind Patil