AutoHotkey Community

hi there!

I currently have a script which gathers system information and specific file versions, the output of the script gets emailed by the customer to me and I put it into an Excel.

This all works so far, just running into a small problem;

I'd like to get an overview of all the physical drives in the system and their corresponding driveletters. I currently do this by reading an XML generated by DXDiag.

I do this using this code:

The reason I'm replacing the commas for an {Enter} and Tabs is that it has to get pasted into the second column of the Excel. What this give me now is this:

Disks ST3500320AS ATA Device
ST3160023AS ATA Device C:
D:

I'd like it to be:

Disks ST3500320AS ATA Device C:
ST3160023AS ATA Device D:

I get this by doing:


this text file is pasted into Excel afterwards on my end and gives the aforementioned result..

Anyone know how to do this?

I can of course FileAppend the 2 variables into 2 seperate text files and paste them manually into the correct column but the problem is that it's not always the same cell in that column. This is because the Dimms are also shown in the same way and some systems have 4, others 6 etc..

DXDiag creates an XML which can list the same drive multiple times when it has more than 1 partition so if anyone knows of a better way let me know..

Thanks ahead!

a) don't paste but use import tab delimited if you must, but
b) even better replace tab enter stuff with CSV which you an open right away in excel for further processing

_________________
AHK FAQ
TF : Text files & strings lib, TF Forum

thanks for replying!

i don't see how using CSV would solve my issue? i would still be creating it using FileAppend? The problem is i can't get the physical drivename followed by it's drive letter {Enter} second physical drivename followed by it's driveletter?

correct me if i'm wrong but i don't see how using CSV would let me do this? it's still a text file created in the same way as the tab delimited file?

Still wrestling with this one, I've now managed to get this information from WMI COM. This still doesn't solve my issue but dxdiag is no longer needed..

This is the syntax I use:


I was wondering if I can query WMI for multiple values in 1 go? Maybe that could 'group' partitions, their hardware, size and driveletters?

Anyone know about this?

_________________
nick

hi nick,

at first i didn't know you can keep the same variable name so i changed disks to disk..

the reason i'm replacing the commas with `n%A_Tab% is so they were pasted into the correct cells in Excel.