Set analysis difference between single quote and double quote

[prasadmundewadi]

As I have read "" in set analysis is user for search and '' is used for exact string.

But when I sun these set analysis both return the same result

1) Sum({$<Country={"C*"}>}Sales)

2) Sum({$<Country={'C*'}>}Sales)

Can anyone explain the difference clearly between the 2 set analysis above?

[hic · Accepted solution]

Today there is no difference between using single or double quotes (or [...] or `...`). They will all be interpreted as quotes defining a search and not a literal match.

But just as stalwar1‌‌‌ points out - it is a bug. Fixing it was more complicated than we thought, so it has still not been fixed. But we are working on it right now and my guess is that we will have it fixed soon.

In the future it will work like this:

• Double quotes: Case insensitive search where * and ? are interpreted as wildcards
• Single quotes: Case sensitive string match where *, ?, =, > and ~ all are treated as any characters

HIC

[Flo_Kopp]

Hey there,

has this already been fixed? Facing same Problem within a customers App.

Best Florian

[Anonymous]

@sunny_talwar "Don't quote me on this..." ...I see what you did there.

:-))

[p_verkooijen]

It seems that the double quote is needed nowadays