Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Korne Script for format file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Korne Script for format file
# 1  
Old 02-21-2005
Korne Script for format file
Hi All,

I am not too familiar with Korne script so I need as much help as possible on this Smilie
What I want to do is: from the excel file on my computer, I want to take certain field from this xls file and put it in txt or cvs format in specific width column. Then fpt this file into the server. Is there anyway I can achieve this?

Thanks

CT
# 2  
Old 02-21-2005
The best way I would do this is to save .xls as .csv file and then delete watever is not needed and then ftp this.
I feel you need to provide more info on this which will make others to help you better.
# 3  
Old 02-21-2005
or you can do one thing ...
get the txt file from excel file ...
ftp the txt file to unix ... do data processing wahtever you want to do.

Ftp back that txt file to windows with comma delimited.

You can open that txt file in Excel with , as delimiter.

Try it ...
# 4  
Old 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
# 5  
Old 02-21-2005
after having the txt file with required fields from original excel file

use awk tool to format the require way you want.

Following is one of the examples

Code:
awk '{printf("%-30s%-20s%-15s\n", $1,$2,$3)}' file1

I understand this is what you want.
# 6  
Old 02-21-2005
bhargav,

You mind to elaborate on the code? I am not familiar with awk so I am not quite sure what are those number are, and "file1" is the name of the file you open or the file you put the output to?

Thanks

CT
# 7  
Old 02-21-2005
file1 is input file.
You can redirect the output by > operator
command > file2 will write the output to file called 'file2'

Using printf of awk , i'm trying to format your input name,id ... etc
with spaces.

man awk for more information.

See the following example to get the idea what i have done.

Code:
$ cat file1
1234 abcd 200
123478 abcd 200889
1234 abcd 200
1234 abcd 200
1234 abcd 200
1234 abcd 200
1234 abcd 200


$ awk '{printf("%-30s%-20s%-15s\n", $1,$2,$3)}' file1
1234                          abcd                200            
123478                        abcd                200889         
1234                          abcd                200            
1234                          abcd                200            
1234                          abcd                200            
1234                          abcd                200            
1234                          abcd                200
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

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

2. Shell Programming and Scripting

Conversion of below Tabs Tex file into CSV format file : shell script needed

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

3. Shell Programming and Scripting

Converting windows format file to unix format using script

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

4. Shell Programming and Scripting

Finding modified File List after the chosen date in Korne Shell...

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

5. Shell Programming and Scripting

Korne Shell...

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

6. Shell Programming and Scripting

Some Problem with Korne Shell//

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

7. Shell Programming and Scripting

Korne Shell Problem.

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

8. Shell Programming and Scripting

script for format a file

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

9. Shell Programming and Scripting

GOTO LOOP in KORNE SHELL

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

10. Shell Programming and Scripting

Mailing in Korne shell

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
Login or Register to Ask a Question