toddson - talk to your hairguy about lowlights - acc'ding to a hair person , it needs less maintenance -it wouldn't nessicarily cover all the grey - just enough to take off some years.

The craxy voice in my head gets like that, GC.

Argh. There's a post-wedding brunch thing this Sunday, I think, that I have already RSVPed for but I can't find the invitation so I don't actually know where or when it is. Why did they not put this info on the wedding website?

Gah. Job Guy 2 sent me the files--a raw data dump with NO field headers. I can only read it as a text file, even in Excel. So I have no way of manipulating the data I need to do this anaylsis.

I emailed him back asking me to send them to me in a tab or comma delimenante format--I'm praying he knows what this is and how to do it. Else I could be screwed.

Does anyone here know how to get a text file into a .csv format so I can do this job? I've tried saving it as .csv but that doesn't do anything.

Can you export it to a csv file through Excel? Caveat: It's been ages since I had to deal with something like that so I could be totally off base.

Cashmere most spreadsheets have parsing tools somewhere, though I can't figure out where the current version of Excel hides it. Email me a copy (my profile addy is good) and I'll be glad to parse them for you if parsable. If these are fixed field lengths and I can figure out where one field ends and another begins from context then parsing it is easy/peasy.

And if I can't find the excel tool, I have an old copy of lotus I know backwards and forwards in terms of doing data parses.

Ah, found the Excel instructions:

1)Select the range of cells that contains the text values. The range can be any number of rows tall, but no more than one column wide. Note There must be one or more blank columns to the right of the selected column or the data to the right of the selected column will be overwritten.

2)On the Data menu, click Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide

I'll try that. Thanks!

oh, TB, I looked at the "author" section of your site. While "what qualifies you to write this book" is the question that you need to answer, I think that it sounds like you're trying to justify yourself. I do, however, love the bit at the end about how to condense it into a blurb.

That bites, Cashmere. Hope the Excel thing works.