Exporting... CSV How to set typical values in KB, MB, GB ???

General discussion related to "Everything".
Post Reply
Debugger
Posts: 565
Joined: Thu Jan 26, 2017 11:56 am

Exporting... CSV How to set typical values in KB, MB, GB ???

Post by Debugger »

Exporting... CSV



"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",1346808

How to set typical values in KB, MB, GB ???

example:
"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",134KB
"Screen Shot 07-18-18 at 04.00 PM.JPG","C:\Users\M\Pictures\My Screen Shots",1MB
void
Developer
Posts: 15096
Joined: Fri Oct 16, 2009 11:31 pm

Re: Exporting... CSV How to set typical values in KB, MB, GB ???

Post by void »

Everything currently only exports sizes in Bytes.

I'll consider an option to export sizes as KB, MB or auto (Bytes/KB/MB depending on size).

For now, you may like to use Excel to convert the size to KB or MB.
vanisk
Posts: 152
Joined: Sat Oct 27, 2018 11:33 am

Re: Exporting... CSV How to set typical values in KB, MB, GB ???

Post by vanisk »

If anyone interested, here's a formula for Spreadhsheet

Assuming Size is in 4th column (D) and data starts on 2nd row

Code: Select all

=IF(D2>1099511627776, ROUND(D2/1099511627776,2) & " TB",IF(D2>1073741824, ROUND(D2/1073741824,2)  & " GB",IF(D2>1048576,ROUND(D2/1048576,2)  & " MB",IF(D2>1024,ROUND(D2/1024,2) & " KB",D2 & " B"))))
Can someone fine tune this pls.
Post Reply