Re: [Clip] Re: Can NoteTab read spreadsheet files?
- Jody had clips for doing this sort of thing. I don't remember an add,
but it would be easy enough to do ... a regex solution might even be
possible I suspect.
Brother Gabriel-Marie wrote:
> Thanks for the tips. I did figure on exporting the text out of the
> excel file; I am using tabs as a delimeter. I found that it is more
> accurate if you manually copy the entire spreadsheet and paste it to a
> text file than using excel's export to tab-delimited text. I don't know
> why, but excel's output removes some tabs.
> Anyways, I found a few clips for grabbing out columns. With that and a
> few powerpro scripts, I think I will manage. Is there a clip out there
> to "add a column"? Say I have one column of values and I want to add
> another column next to it, delimited. I found a clip to extract the
> column, but not to add it. I also found a clip to extract a field from
> the whole sheet - I don't remember what library they came from, however.