04-04-2009
Thx for the reply, but I figured out how to do what I needed with a .vbs script.
If I was on my work laptop, i'd post a snip-it of the code used as an example for others.
That's how I figured it out, I found a snip-it similair to what I needed and tailored it to my application.
I'll try to remember on monday to add the code...
Thx again.
Now if anyone has an example of .vbs or PERL that can parse data and then stick it in an excel spreadsheet, i'd be a happy camper.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have created get_list.bat file containing following line:
dir /B /O-d >file_list.txt
I am executing ftp command from Unix box and transferring get_list.bat file to windows server.
In my next ftp command I am trying to execute this test.bat file by entering this line:
get_list
or by... (9 Replies)
Discussion started by: alx
9 Replies
2. Windows & DOS: Issues & Discussions
Hello,
Is there a way to trigger a Windows bat file or program on a different machine from a different UNIX server using KSC file?
I hope you can assist me with this.
Thanks! (0 Replies)
Discussion started by: punyenye
0 Replies
3. UNIX for Dummies Questions & Answers
Hi, can you run a windows bat file or a VBscript from a shell script?
#!/bin/sh
PATH=/
$PATH/test.bat (1 Reply)
Discussion started by: cmac
1 Replies
4. UNIX for Advanced & Expert Users
Hi
Can anyone tell if it is possible to connect from Unix to t a remote windows environment and run a .bat script.
Do SSH/SFTP... serve my purpose..if s how....
if not which commands or scripts will help with my requiremnt.
points on this are greatly honoured.
Thanks in advance.
:) (1 Reply)
Discussion started by: lakshmis10
1 Replies
5. UNIX for Dummies Questions & Answers
Hi folks,
I have a file in unix box as abc.xls and i have a file in windows box as abc_win.xls. Now if i open the file abc_win.xls which is in windows, i have to get the datas of the file abc.xls which is in unix. Everytime i opens the abc_win.xls file, the updated datas of file abc.xls... (6 Replies)
Discussion started by: a439511
6 Replies
6. UNIX for Dummies Questions & Answers
Hi ,
I am having file in unix with size (386796649) , below is the output of ls command in UNIX.
I have ftp'ed the file to my windows machine . When i tried to open the file it is not
opening . Why it is so . Is there is size limit.
-rw-rw-rw- 1 p10 pQQ 98473 Sep 17 17:20... (4 Replies)
Discussion started by: arunkumar_mca
4 Replies
7. Shell Programming and Scripting
Experts,
I am newbie in shell scripting. I want to write Bash shell scripts corresponding to windows bat files. I have installed cygwin at c:\cygwin and i am trying to crate the sh file using vi editor. i am not able to understand how to use linux/unix convention for the code. following is my... (1 Reply)
Discussion started by: rajuchacha007
1 Replies
8. Shell Programming and Scripting
Experts,
I am newbie in shell scripting. I want to write Bash shell scripts corresponding to windows bat files. I have installed cygwin at c:\cygwin and i am trying to crate the sh file using vi editor. i am not able to understand how to use linux/unix convention for the code. following is my... (15 Replies)
Discussion started by: rajuchacha007
15 Replies
9. Windows & DOS: Issues & Discussions
How can I start an application sitting on a windows machine (XP) from Unix shell script (AIX server) ? (6 Replies)
Discussion started by: pkan
6 Replies
10. Shell Programming and Scripting
I am zipping a file in unix and then sending it to windows.
buyt when i try to open it with 7zip software. it throws an error FILE IS BROKEN (3 Replies)
Discussion started by: rafa_fed2
3 Replies
PSC(1) General Commands Manual PSC(1)
NAME
psc - prepare sc files
SYNOPSIS
psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
DESCRIPTION
Psc is used to prepare data for input to the spreadsheet calculator sc(1). It accepts normal ascii data on standard input. Standard out-
put is a sc file. With no options, psc starts the spreadsheet in cell A0. Strings are right justified. All data on a line is entered on
the same row; new input lines cause the output row number to increment by one. The default delimiters are tab and space. The column for-
mats are set to one larger than the number of columns required to hold the largest value in the column.
OPTIONS
-f Omit column width calculations. This option is for preparing data to be merged with an existing spreadsheet. If the option is not
specified, the column widths calculated for the data read by psc will override those already set in the existing spreadsheet.
-L Left justify strings.
-k Keep all delimiters. This option causes the output cell to change on each new delimiter encountered in the input stream. The
default action is to condense multiple delimiters to one, so that the cell only changes once per input data item.
-r Output the data by row first then column. For input consisting of a single column, this option will result in output of one row
with multiple columns instead of a single column spreadsheet.
-s cell
Start the top left corner of the spreadsheet in cell. For example, -s B33 will arrange the output data so that the spreadsheet
starts in column B, row 33.
-R n Increment by n on each new output row.
-C n Increment by n on each new output column.
-n n Output n rows before advancing to the next column. This option is used when the input is arranged in a single column and the
spreadsheet is to have multiple columns, each of which is to be length n.
-d c Use the single character c as the delimiter between input fields.
-P Plain numbers only. A field is a number only when there is no imbedded [-+eE].
-S All numbers are strings.
-v Print the version of psc
SEE ALSO
sc(1)
AUTHOR
Robert Bond
PSC 7.16 19 September 2002 PSC(1)