Multiple files in multiple directories and only return the unique values

Content Authoring
1

Hi all
I have to get the unique values from the same named file which is in multiple sub directories
ie
(unique values of it) of (line 3 of files whose (name of it contains “version.txt”) of folders of folders of folder ("__GTS/__IEMHC/") of storage folder of client)

I get the version i am looking for but also E: Singular expression refers to non-unique object.
I know there are multiple versions of the file, but I wish to get rid of the error.

any and all help is appreciated

2

try lines 3 of files whose ()
with the plural “lines”

3

hi Jason
I did actually, it returns all lines which are all the same,
unique values of it is same
Q: (unique value of it) of (lines 3 of files whose (name of it contains “version.txt”) of folders of folders of folder ("__GTS/__IEMHC/") of storage folder of client)
A: 3.8.0
A: 3.8.0
A: 3.8.0
A: 3.8.0
A: 3.6.0
A: 3.8.0
T: 3685

I want just 3.8.0 and 3.6.0

4

Oh, okay, but you don’t get the “non-unique object” error this way.

The issue now is the scoping that you’re doing with (unique value of it). By using the parentheses, you are examining each result separately.

The first time in (unique value of it), you are looking at the single result “3.8.0”. It’s unique value is 3.8.0. The second time in, you’re looking at the single result for the second instance of “3.8.0”, which also has a unique value 3.8.0 and is also returned. …etc.

To get around that, don’t use the parentheses, so you look at “all the results” instead of “each of the results”.

Q: unique values of (lines 3 of files whose (name of it contains “version.txt”) of folders of folders of folder ("__GTS/__IEMHC/") of storage folder of client)

It should also work in a slightly more simplified form where the only parenthses is for the whose() clause
Q: unique values of lines 3 of files whose (name of it contains “version.txt”) of folders of folders of folder "__GTS/__IEMHC/" of storage folder of client

5

Hi Jason
Thanks for the explanation.
These examples you gave work, and a friend of mine also came up with this

( it ) of unique values of (lines 3 of files whose (name of it contains “version.txt”) of folders of folders of folder ("__GTS/__IEMHC/") of storage folder of client)

So 3 working examples, perfect thanks!!!