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 Functionand 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 SHI 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