08-23-2009
How to read from txt file and write it to xls?
Hello All,
I just want help in coding a simple shell script since i am a newbie for UNIX and i started learning unix and shell scripting basics recently.
I am having a data like this in .txt file.
Product Name : XYZ
Price : 678.1
Best Buy Price : 600
Product Name : ABC
Price : 465
Best Buy Price : 450
and so on..
Now i want to read these datas from the text file and write into a excel file in seperate columns such as
PRODUCT NAME PRICE BEST PRICE
XYZ 678.1 600
ABC 465 450
I hope i will get help with this..
thanks in advance..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to take the totals from my script and input them into a excel spreadsheet. Right now, I just copy and paste. Is there an easier way?
3906
is the total jobs in ABEND state
4005
is the total jobs in SUCC state
1050
is the total jobs in HOLD state (1 Reply)
Discussion started by: wereyou
1 Replies
2. Shell Programming and Scripting
How to convert a txt file(tab delimiter) to xls file.
Looking forward help.
Thanks,
Venkatesh. (2 Replies)
Discussion started by: venkatesht
2 Replies
3. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
4. UNIX for Dummies Questions & Answers
i want to convert a comma seprated file into a .xls file
the file contains 3 fields seprated by a comma.
i want to convert it into a .xls file with 3 columns and 37 rows
DPRPT400,01/15/2009-15:03:06,01/15/2009-15:03:08
DPRPT401,01/15/2009-15:03:15,01/15/2009-15:03:32... (11 Replies)
Discussion started by: manit
11 Replies
5. UNIX for Dummies Questions & Answers
Hello,
I have a set of .txt files I cannot read.
This is a part of what I see.
Is there a way to view these files?
_MO<P.6D@K;WU<B$X-;)SIV/ROO!UL+1P=VTT-?,SLC`MI/6QMS#UYGGT\+)C=#\UIO`TL/0]=#/T)
it's about 3 pages.
Thanks for your help.
Joe (3 Replies)
Discussion started by: rcracerjoe
3 Replies
6. Shell Programming and Scripting
Hi,
i don't know anything about PERL. Can anyone help me providing PERL scripts for
1. converting XLS to CSV (and vice-versa)
2. converting DOC/RTF to TXT
Thanks much
Prvn (1 Reply)
Discussion started by: prvnrk
1 Replies
7. Shell Programming and Scripting
Could anyone very kindly help me a simple way to perform the - perhaps - very trivial task of writing the name of a file as first line of that file which is in txt format?
And would be possible to do this recursively for some thousands files in the XY directory?
And, again, add to the simple... (3 Replies)
Discussion started by: mjomba
3 Replies
8. Shell Programming and Scripting
Hi ,
I am getting data as below for one of my table as below in a .txt format.I am manually opening a xls sheet, and then selecting import data from option and importing the data in to xls and then saving it as .csv file and this .csv file I am using for one of the shell script.
I am... (3 Replies)
Discussion started by: shruthidwh
3 Replies
9. Shell Programming and Scripting
Script to take .xls file and read it for each server "/aix/test/$server_pre.xls" and then removes all the disks as provided in the file and then give output as below for each server, but am getting error where it says cannot find directory.
server_name: server1
Disk Cleaned
hdisk1 hdisk1... (2 Replies)
Discussion started by: aix_admin_007
2 Replies
10. UNIX for Dummies Questions & Answers
Hi All,
Just have a requirement, I am executing a bash shell script, my requirement is to catch the pid and job name to a txt file in the same directory, is there anyway to do it? please help me out.
Regards
Rahul
---------- Post updated at 08:42 AM ---------- Previous update was at... (2 Replies)
Discussion started by: rahulkalra9
2 Replies
sh(1) General Commands Manual sh(1)
NAME
sh - Shell, the standard command language interpreter
DESCRIPTION
[Tru64 UNIX] Tru64 UNIX provides two command interpreters with the name sh. The XCU5.0 and POSIX.2 compliant command interpreter sh is
available in the file /usr/bin/posix/sh and is described in the sh(1p) reference page. The Bourne shell, historically known as sh, is
available in the file /usr/bin/sh and is described in the sh(1b) reference page.
[Tru64 UNIX] Your initial, or login, shell is determined by your entry in the file /etc/passwd. This file can be changed only by your sys-
tem administrator. You must use whatever procedures are in place at your location to have this entry changed.
[Tru64 UNIX] If available on your system, you may use the passwd -s or the chsh commands to change your login shell.
Note
This option is not available if your site manages passwords through the Network Information Service (NIS) facility. Check with your system
administrator.
[Tru64 UNIX] Subsequent shells spawned from the initial shell depend on the value in the environment variable BIN_SH. If this variable is
set to xpg4, the POSIX shell is started. If this variable is set to svr4, an SVR4 compliant version of the shell is started. If this vari-
able is unset, the Bourne shell is started. If this variable is set to any other value, an error is reported and the results are unpre-
dictable. See the EXAMPLES section for information on setting this variable.
NOTES
[Tru64 UNIX] With Tru64 UNIX Version 4.0 the Korn shell, /usr/bin/ksh is the same as the POSIX shell /usr/bin/posix/sh.
RESTRICTIONS
[Tru64 UNIX] The file /etc/shells must include entries for both the POSIX shell /usr/bin/posix/sh and the Bourne shell, /usr/bin/sh. If
this file is incorrect, see your system administrator.
EXAMPLES
Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the POSIX/ XCU5.0compliant shell, enter: BIN_SH=xpg4 export
BIN_SH Using the Bourne, Korn, or POSIX shell, to set the variable BIN_SH to use the SVR4 compliant shell, enter: BIN_SH=svr4 export BIN_SH
Using the Bourne, Korn, or POSIX shell, to unset the variable BIN_SH, enter: unset BIN_SH Using the C/ shell, to set the variable BIN_SH to
use the POSIX/XCU5.0 compliant shell, enter: setenv BIN_SH xpg4 Using the C/ shell, to set the variable BIN_SH to use the SVR4 compliant
shell, enter: setenv BIN_SH svr4 Using the C/ shell, to unset the variable BIN_SH, enter: unsetenv BIN_SH
FILES
User profile. Contains user information, including the login shell name. Contains the names of available and permitted shells.
SEE ALSO
Commands: csh(1), ksh(1), Bourne shell sh(1b), POSIX shell sh(1p), passwd(1)
Files: passwd(4), shells(4)
Standards: standards(5)
sh(1)