[project1dev] Re: [Offtopic] Excel Question
- From: Alan Wolfe <alan.wolfe@xxxxxxxxx>
- To: project1dev@xxxxxxxxxxxxx
- Date: Wed, 12 May 2010 16:12:43 -0700
"hrm whats your source file look like when you first get it, can you paste a
portion of it?"
i mean what does it look like if you open it up in notepad or another "raw
viewer" program
On Wed, May 12, 2010 at 4:11 PM, Alan Wolfe <alan.wolfe@xxxxxxxxx> wrote:
> hrm whats your source file look like when you first get it, can you paste a
> portion of it?
>
> and then are you just copy/pasting the file into excel so excel can do the
> magic for you with some script? (excel i think supports vb script which
> should let you do whatever you want, come to think of it)
>
> And one more... what generates the raw data that you get? IE is it a php
> file on a server you have (or could get) access to by chance?
>
>
> On Wed, May 12, 2010 at 4:02 PM, Nick Klotz <roracsenshi@xxxxxxxxx> wrote:
>
>> My source data is a generic HTML file with no formatting. I'm taking
>> the raw data and making some reports from the info, but I was
>> wondering if there was an easier way to do what I needed without
>> destroying the data.
>>
>> On Wed, May 12, 2010 at 7:01 PM, Alan Wolfe <alan.wolfe@xxxxxxxxx> wrote:
>> > I could be wrong but i think that in excel you can't make something that
>> > removes values from columns.
>> >
>> > are you trying to use excel to convert data from one format to a
>> different
>> > format?
>> >
>> > If so, people use python for this quite a bit, but you could also bust
>> out
>> > some of your c++ if you wanted.
>> >
>> > If my assumptions are correct so far... where are you getting your
>> source
>> > data and what format is your source data in? (ie is it a csv file or
>> what?)
>> >
>> > On Wed, May 12, 2010 at 3:54 PM, Nick Klotz <roracsenshi@xxxxxxxxx>
>> wrote:
>> >>
>> >> sorry, look at the PNG image instead
>> >>
>> >>
>> >> all the formatting got messed up
>> >
>> >
>>
>> ==============================
>> Project 1 Dev mailing list
>> to unsubscribe, please send an email request to demofox@xxxxxxxxxxx
>> Project 1 website: http://project1.demofox.org
>> Project 1 SVN repository: http://pyotek.com/project1
>>
>
>
Other related posts:
