How do I use excel to create a unix script?
 

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?

How do I use excel to create a unix script?
 

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.

"Nanette" wrote in message
...
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?

How do I use excel to create a unix script?
 

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?

How do I use excel to create a unix script?
 

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

"Luke Alcatel" wrote:

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.

"Nanette" wrote in message
...
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?

How do I use excel to create a unix script?
 

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..

"Nanette" wrote:

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

"Luke Alcatel" wrote:

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.

"Nanette" wrote in message
...
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?