excel - Extract set of numbers from a string, subtract and then add them with certain exclusions -

-

i'm not great excel formulas, have excel column 'logical diskspace', each cell of has similar value below. 

 | disk c: (ntfs)20.9731 gb (3.7077 gb free space)  | disk e:  (ntfs)107.3767 gb (22.7083 gb free space)  | disk f: (ntfs)107.3767 gb  (38.0516 gb free space)  | disk g: (ntfs)53.6781 gb (21.7887 gb free  space)  | disk p: (ntfs)4.7252 gb (0.5997 gb free space)

what need find total used capacity excluding c: drive.

taking above example, should calculate follows:

exclude c: + (107.3767-22.7083)+(107.3767-38.0516)+(53.6781-21.7887)+(4.7252-0.5997)

note number of drives may vary delimited '|' sign.

could me programmatic approach achieve this?

vba not necessary tedious more 1 time without record macro activated. series of find , replace:

find, in turn:

free space) |disk
free space)
: (ntfs)
gb

and replace each nothing (the first , last above start space).

find ( replace -
find, in turn f, g , p , replace each +

find |disk*e , replace =.


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

c# - Get rid of xmlns attribute when adding node to existing xml -

-
i have xml-file: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:d>some content</d> </a> </root> i need add new node in specific place, code is: var doc = xdocument.load(file); xnamespace ns2 = "namespace"; doc.element(ns2 + "root").element(ns2 + "a").element(ns2 + "c").addafterself( new xelement(ns2+"new", new xelement("new1", new xelement("new2","some content"), new xelement("new3", "some content")))); the output is: <ns2:root xmlns:ns2="namespace"> <ns2:a> <ns2:b>some content</b> <ns2:c>some content</c> <ns2:new> <new1 xmlns=""> <new2>some content</new2> ...
Read more