02-21-2005
I want only certain field from that xls file, and the output file in txt or cvs has to be in certain width colume like ID is from column width 1-20, name from column width 21-40 ....up to 300+ character in one line.
I got a table set up in MS Access with those column width defined, then copy and paste the data that i want from the excel file into that table. After that, i export the table to txt or cvs format with "fix width" option.
Then i have to fpt this file into the server. This works but takes too much time. So i was just wonder if there is a better way.
Thanks
CT
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
All
Iam using Korne shell in AIX OS. Can u give me the syntax to send a mail.
Thanx in advance
Regards
Deepak (5 Replies)
Discussion started by: DeepakXavier
5 Replies
2. Shell Programming and Scripting
All
Please help to provide "goto" functionality in KORN shell script.
ex:
1: Command
Process some command
if check some variable
true
goto 1
else
process some other
Please help to implement this example in korne... (1 Reply)
Discussion started by: DeepakXavier
1 Replies
3. Shell Programming and Scripting
is there any way to format a file by just removing first line and last line from the file.
my file is like
test.txt
12may2004,20may2004,A
123,SCOTT,TIGER,,,,12,12-MAY-2006
124,TIGER,SCOTT,,,,,,,
....
...
163,cscssaa,abc,,,,12,12-MAY-2006
END
my requirement is to produce the same file... (1 Reply)
Discussion started by: u263066
1 Replies
4. Shell Programming and Scripting
Hi Everyone,
I have tried with the following Code for each of the following, but that does not seem to serve the purpose. Can someone give some pointers please.
1) A Korne Shell which asks the user to enter the name of a file when searching it
recursively (using the find command) in the... (3 Replies)
Discussion started by: marconi
3 Replies
5. Shell Programming and Scripting
I am new to Korne Shell Scripting. Can someone help me with a Korne Shell which asks the user :-
1) to enter the name of a file when searching it recursively (using the find
command) in the home directory of this user.
2) for a date (format AAMMJJ) and a directory and then searches ... (4 Replies)
Discussion started by: marconi
4 Replies
6. Shell Programming and Scripting
In Korne Shell Scripting, how to search recursively in a directory, the list of files modified after a given date ..
Thanks in advance.. (1 Reply)
Discussion started by: marconi
1 Replies
7. Shell Programming and Scripting
I am trying to write a Korne Shell asking the user for a date and a directory and then search recursively in this directory the list of files modified after the date chosen. But I am not getting good results when I Test it...
#!/usr/bin/ksh
echo "Enter a date (YYYYMMDD) "
read date
touch -t... (2 Replies)
Discussion started by: marconi
2 Replies
8. Shell Programming and Scripting
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies
9. Shell Programming and Scripting
Request if some one could provide me shell script that converts the below "input file" to "CSV format file" given
Name Domain Contact Phone Email Location
----------------------- ------------------------------------------------ ------- ----- ---------------------------------... (7 Replies)
Discussion started by: sreenath1037
7 Replies
10. Shell Programming and Scripting
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT LINUX
shtool-table
SHTOOL-TABLE.TMP(1) GNU Portable Shell Tool SHTOOL-TABLE.TMP(1)
NAME
shtool-table - GNU shtool pretty-print a field-separated list
SYNOPSIS
shtool table [-F|--field-sep sep] [-w|--width width] [-c|--columns cols] [-s|--strip strip] strsepstr...
DESCRIPTION
This pretty-prints a list of strings as a table.
OPTIONS
The following command line options are available.
-F, --field-sep sep
Separate columns using sep. Default is ":".
-w, --width width
Width of each column. Default is 15 characters.
-c, --columns cols
Number of columns. Default is 3.
-s, --strip strip
Strip off any characters past strip. Default is 79.
EXAMPLE
# shell script
shtool table -F , -w 5 -c 4 "1,2,3,4,5,6,7,8,9,10,11,12"
HISTORY
The GNU shtool table command was originally written by Ralf S. Engelschall <rse@engelschall.com> in 1999 for GNU shtool.
SEE ALSO
shtool(1), tr(1), fmt(1), sh(1), awk(1), sed(1).
18-Jul-2008 shtool 2.0.8 SHTOOL-TABLE.TMP(1)