So those number 30, 20, 15 are the width of the field that you want it to be? like id has 30 characters, name has 20 character..and so on?
what if i want to have other things that are not on the original file in the new file also? Example:
file1, original file, have 4 colume : id, first name, last name, amount
i want the file 2 to be in the format:
--------------------------------------------------------------------------
V2
Uid lastname, firstname date school account amount00
--------------------------------------------------------------------------
Here is the actual output that i export form the MS Access (it is all in one line, with V2 on the very first line. id= 000702687, lastname=Adams, firstname=Abigail, amount= 200 (last one on the line, with extra 2 zero's)
(it is at certain column width, but it won't show that in here when i paste it in) [Edit --- it will if you use code tags. I have added them. -- Perderabo]
Thanks
CT
Last edited by Perderabo; 02-21-2005 at 06:14 PM..
Reason: Add code tags for readability
I test some awk code, i think i get the idea how to manipulate the date, however, I can't quite get it the way i want
Here is the txt file that i have:
How do i get the colume where "AD...." start to align? the last name doesn't have fix width so it's hard to specify how many character do i need.
Thanks
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)
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)
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)
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)
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)
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)
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)
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)