Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
btw
the expression returns the correct result and shows me the 5 files, however it does not select them
Regards
Alan
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
I was thinking of that too but it does not work
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) &')'