Shorting the content DB from enumlist.txt

this morning try to get the URL and Database from enumlist for orphan object checking , but after import to excel with delimited but look like the information is not good enough. ha ha, then learnt some excel function to short it out. so want to keep track new excel command i learnt :

 

<Site Url=http://abc.abc.com Owner="abc\abc" ContentDatabase="MOSS_Content_DB1" StorageUsedMB="28.7" StorageWarningMB="80" StorageMaxMB="100" />

 

this command is trim up the front part

=RIGHT(A1,LEN(A1)-FIND("e=",A1))

 

Results is :

="MOSS_Content_DB1" StorageUsedMB="28.7" StorageWarningMB="80" StorageMaxMB="100" />

 

Another column  is trim out the left over

=LEFT(B2,(FIND("St",B2)))

 

Results is:

="MOSS_Content_DB1" S

 

At last replace the “ and “ S with space, then you will get the DB name :)

 

Maybe look stupid , but i get what i want!! i think will have more easy way , but i unable to think out yet. so i just use the faster skill i know to get my information i think this is fair.

 

please do share with me the easy way , if you have :)