Select Top Five Files but what about spaces?

[rustyfishbones]

Hi All,

I have the following expression used in a Select in Field to Select the 5 biggest files based on File Size

'(' & CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]),'|') &')'

however it does not work, I believe it's because there are spaces in the Full Path name

What can I add to the above expression to resolve it

Regards

Alan

[rustyfishbones]

btw

the expression returns the correct result and shows me the 5 files, however it does not select them

Regards

Alan

[marcus_sommer · Accepted solution]

Maybe you need each value wrapping in single/double-quotes, like:

'(' & chr(39) CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]), chr(39) & '|' & chr(39)) & chr(39) &')'

- Marcus

[rustyfishbones]

I was thinking of that too but it does not work

[rustyfishbones]

Actually, I just replaced CHR(39) with CHR(34)

And it worked

So the working Expression is

='(' & chr(34) & CONCAT(IF(AGGR(RANK(SUM(Size)),[Full Path])<=5,[Full Path]), chr(34) & '|' & chr(34)) & chr(34) &')'