Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Technology Stocks : WDC/Sandisk Corporation -- Ignore unavailable to you. Want to Upgrade?

To: Ausdauer who wrote (6421)	7/17/1999 10:19:00 PM
From: Gary Spiers	Read Replies (1) \| Respond to of 60323

Aus, I finally found someone with more free time on their hands than I. It only took 5 minutes of effort to spit that list out - in between pressure washing the back patio and taking the children to the park :-) To do it simply: - highlight the list in web browser and copy it - Paste into Excel as unicode text - Use Excels text to columns parser to split things into columns by using 'space' as the delimiter - convert all MB values (eg 100MB) from text to numbers using the formula =VALUE(LEFT(B1,LEN(B1)-2) where column B1 contains the text "100MB". The LEFT(B1,LEN(B1)-2) portion deletes the "MB" from the end of the number and then the VALUE() function wrapped around it converts the text into a number. This is the automated step that saves the most time otherwise doing this by hand would be slow. - add a column to divide size by $ - delete surplus columns of text - copy and paste table into message to forum - take children to park I don't think that the 48 MB card selling for $100.OO represents a loss leader I agree with you - bad choice of words on my part and by the time I'd thought about it my 15 minutes (for reediting) were up. GaryS