How do I use excel to create a unix script?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nanette - 08 May 2006 17:03 GMT

I'm trying to use excel to create some simple unix scripts. When ever I set
up my data in excel I use copy and paste to put it into a text document.
Doing this introduces unnecessary spaces that I end up manually removing.
Any suggestions?

Reply to this Message

Luke Alcatel - 08 May 2006 17:19 GMT

Nanette,
I'm not sure I understand the problem you are describing. If text in your
cells have unnecessary leading and trailing spaces why not just use trim()
in the VBA module that generates the Unix scripts? Again, maybe I don't
understand your explanation.

> I'm trying to use excel to create some simple unix scripts. When ever I set
> up my data in excel I use copy and paste to put it into a text document.
> Doing this introduces unnecessary spaces that I end up manually removing.
> Any suggestions?

Reply to this Message

Nanette - 08 May 2006 17:57 GMT

Luke,

I have 3 columns of information

1is the command (modify) 2 the account to take action on 3 the attribute
being changed
m 6712945678
F104=99

I might have a thousand of the same rows, but #2 the account needs to
change. I make a text file and then post that file to the system. But when
I use excel spaces are present in my text file that I've ended up manually
removing.

Thanks for any help

> Nanette,
> I'm not sure I understand the problem you are describing. If text in your
[quoted text clipped - 7 lines]
> > Doing this introduces unnecessary spaces that I end up manually removing.
> > Any suggestions?

Reply to this Message

Kevin - 22 Jun 2006 21:20 GMT

I do this a lot, if you just copy the cells and paste them it introduces a
space between where the cell dividers were.
If you have info in cell a1, a2 and a3 and want to put in into a unix file
or commande line then put a simple formula into cell a4 that says something
like:
"=a1&a2&a3" This will combine all of the info in a1,a2,a3 into one line of
text. You can then copy cell a4 into the unix window..

> Luke,
>
[quoted text clipped - 23 lines]
> > > Doing this introduces unnecessary spaces that I end up manually removing.
> > > Any suggestions?

Reply to this Message

aidan.heritage@virgin.net - 08 May 2006 17:21 GMT

I think you need to OPEN the text file for output, then WRITE to it
from code, before closing it - I would never use the copy and paste
method in code - too problematic, and what if a user starts doing
something else while the macro is running?

Reply to this Message