asked on
How to identify ATTRIBUTE column in exported data from WizTree
Hi Exports!
I have been using WizTree from Diskanalyzer, a recommendation from of the Experts in a previous question (it has been a great tool). Today I started exporting data from the apps to further analize and found that Attributes is exported in a value instead og A, H, R, etc. (as the link WizTree Guides (diskanalyzer.com) states:
The excel I am working with is over 40,000 lines and the "Attribute" column has given the following values:
0 | 38 | 8,226 |
1 | 288 | 8,230 |
2 | 550 | 8,231 |
3 | 8,192 | 268,435,456 |
6 | 8,194 | 536,870,918 |
32 | 8,196 | 536,870,950 |
33 | 8,198 | 2,147,483,654 |
34 | 8,224 | |
35 | 8,225 |
I have tried to calculate the above values to identified what combination could be (ex. ARH)
How can I identify what is the actual attribute?
Thank you in advance
For older version of Excel you can try a UDF.
Function attr(c As Integer)
Dim binc As String
Dim i As Integer
binc = WorksheetFunction.Dec2Bin(c)
For i = 1 To Len(binc)
attr = IIf(Mid(binc, Len(binc) + 1 - i, 1) = 1, _
Choose(i, "R", "H", "S", "", "", "A", "", "", "", "", "C"), "") & attr
Next i
End Function
and call it with
=attr(A2)
ASKER
Thank u guys!
David Johnson, CD,
I ran the script and only 0, 8192 and 268435456 returned No Info (see results below)
WizTree Value | PS Results |
0 | no info |
1 | R |
2 | H |
3 | HR |
6 | SH |
32 | A |
33 | AR |
34 | AH |
35 | AHR |
38 | ASH |
288 | A |
550 | ASH |
8192 | no info |
8194 | H |
8196 | SH |
8198 | SH |
8224 | A |
8225 | AR |
8226 | AH |
8230 | ASH |
8231 | ASHR |
268435456 | no info |
536870918 | SH |
536870950 | ASH |
2147483654 | SH |
Hi byundt,
- About the columns, is only one, I just divided in for viewing and placed a comma - in answering David Johnson, CD, I placed it in one column
- Unfortunately, I couldn't test your formula, I have here Excel 2010, can u provide in v2010?
Hi Saqib Husain,
I compare your script against Davids and 0 then 550 thru 2147483654 couldn't identify it.
ASKER
Yes, thanx, same results as David Johnson, CD.
However, I still haven't been able to identify the missing value: 1, 8192, 268435456
I will spot check the files against the script going directly to the files and run "ATTRIB" (or see their Propeties)
ASKER
Status:
There are over 10 million files, so I spot check a lot to see if u guys script didn't square off, they did (I compare u guys result with the actual file ans matches the script result_ - except the below:
0 = seems ia file with no attributes
8192 = ?
268435456 = ?
2147483654 = could be SH
I will proceeds to close the question, if u guys find out the above missing, greatly appreciated
I assume that only the first column in your sample data represents the file attribute values. I say this because I can decode each of those values as a combination of R, H, S, A & C. I cannot make a similar decode for the other two columns.
Each of the values being added are a power of 2, so you can look at different bit positions to determine whether R, H, S, A or C are present.
If you have Excel 2021 or Microsoft 365, you may use the following formula to convert the sum in cell A2 into a code like AHR.
Open in new window