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

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

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

Post by Debugger » Sat Jan 12, 2019 7:43 pm

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
Site Admin
Posts: 4438
Joined: Fri Oct 16, 2009 11:31 pm

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

Post by void » Mon Jan 14, 2019 8:10 am

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: 76
Joined: Sat Oct 27, 2018 11:33 am

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

Post by vanisk » Mon Jan 14, 2019 10:15 am

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