05-03-2011
Scripting using flat files
I need some help to create a script that can do the following:
I have two flat files with one column that should link the two files' information into one record:
1st Flat File - 3 columns, multiple rows:
orderid, Jobnumber, Ordernumber
2nd Flat File - 2 columns, multiple rows:
Ordernumber, Member
By using the 'Ordernumber' to link these files together, I need the output in a seperate file like this:
Orderid, Jobnumber, Ordernumber, Member
Thanks for any assistance!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a flat file like this
0001 THER ULT HEAD & NECK VES
0002 THER ULTRASOUND OF HEART
0003 THER ULT PERIPHERAL VES
0009 OTHER THERAPEUTIC ULTSND
0010 IMPLANT CHEMOTHERA AGENT
0011 INFUS DROTRECOGIN ALFA
0012 ADM INHAL NITRIC OXIDE
I need to conver this to a comma delimited flat file... (2 Replies)
Discussion started by: thumsup9
2 Replies
2. Shell Programming and Scripting
Hi Gurus,
I searched the forum but didnt get much info.
I want to compare 2 files.
1)Newfile comes today with
2)Old file of previous day.
The files are same ,just the new files might have new records sometimes.
So I want to capture these new records in another file.
Can anyone help... (5 Replies)
Discussion started by: ganesh123
5 Replies
3. Shell Programming and Scripting
Hi all,
I have to generate a tab-delimited flat file. Since few days, I have been getting * in random accounts.
For example, an account supposed to have the value 123456789123,123
Now this is supposed to be in a 12,3 format.
Please note that this being a German field, the comma (,) here... (3 Replies)
Discussion started by: ctrl_alt_del
3 Replies
4. UNIX for Advanced & Expert Users
We are using sybase data base and we have the data base name called MasterDB. The data baase MasterDB contains 100's of tables like sample1, sample2, sample3...etc...sample100
To take the count of every table we have to execute the following commands
use MasterDB //DB name
go //execute... (1 Reply)
Discussion started by: shijoe
1 Replies
5. Shell Programming and Scripting
We are using sybase data base and we have the data base name called MasterDB. The data baase MasterDB contains 100's of tables like sample1, sample2, sample3...etc...sample100
To take the count of every table we have to execute the following commands
use MasterDB //DB name
go //execute... (1 Reply)
Discussion started by: shijoe
1 Replies
6. Shell Programming and Scripting
Ok,
so i've been having to write to flat files lately and then making my script read information from the flat file and then work off of that.
i dont want to keep doing that because i believe it creates a mess. i like to keep my work all to one script instead of having that one script... (7 Replies)
Discussion started by: SkySmart
7 Replies
7. Shell Programming and Scripting
I am new to shell scripting and I have to to the following
I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file.
Like the following str00001.txt
StoreName emailaddress location... (3 Replies)
Discussion started by: willywilly
3 Replies
8. Shell Programming and Scripting
Hi Frnds,
I have a flat file with millions of records. .
Now I on this. (I prefer for AWK as its gives good performance.)
Old_file.txt
------------------
1 gopi ase ....
2 arun pl ...
3 jack sutha ..
4 peter pm ..
...
New_file.txt
---------------
4 peter pm ..
..
... (12 Replies)
Discussion started by: Gopal_Engg
12 Replies
9. Shell Programming and Scripting
Hi,
How to add trailer record at the end of the flat file in the unix ksh shell scripting
can you please let me know the procedure
Regards
Srikanth (3 Replies)
Discussion started by: srikanth_sagi
3 Replies
10. Shell Programming and Scripting
How to convert this:
F1-R1 F1-R2 F1-R3 into a flat file for bash?? Each record
F2-R1 F2-R2 F2-R3
F3-R1 F3-R2 F3-R3
F4-R1 F4-R2 F4-R3is on one line with all fields for that record, put into an output file. The output file should look like this when converted:
F1-R1,F2-R1,F3-R1,F4-R1... (6 Replies)
Discussion started by: bud1738
6 Replies
LEARN ABOUT REDHAT
column
COLUMN(1) BSD General Commands Manual COLUMN(1)
NAME
column -- columnate lists
SYNOPSIS
column [-tx] [-c columns] [-s sep] [file ...]
DESCRIPTION
The column utility formats its input into multiple columns. Rows are filled before columns. Input is taken from file operands, or, by
default, from the standard input. Empty lines are ignored.
The options are as follows:
-c Output is formatted for a display columns wide.
-s Specify a set of characters to be used to delimit columns for the -t option.
-t Determine the number of columns the input contains and create a table. Columns are delimited with whitespace, by default, or with
the characters supplied using the -s option. Useful for pretty-printing displays.
-x Fill columns before filling rows.
Column exits 0 on success, >0 if an error occurred.
ENVIRONMENT
COLUMNS The environment variable COLUMNS is used to determine the size of the screen if no other information is available.
EXAMPLES
(printf "PERM LINKS OWNER GROUP SIZE MONTH DAY HH:MM/YEAR NAME
"
; ls -l | sed 1d) | column -t
SEE ALSO
colrm(1), ls(1), paste(1), sort(1)
HISTORY
The column command appeared in 4.3BSD-Reno.
BSD
June 6, 1993 BSD