05-25-2012
Help with file manipulation script
I am a UNIX newbee . I have been doing some reading lately but really need help with an an urgent requirement.After almost two days of googling I end up with 0 luck. Hopefully a guru on here will be able to help me out. Here is my requirement:
I have 20 files in a directory with detail records in them. Each detail file has a corresponding Trailer file in the same directory . Both detail and trailer files are fixed width. I need to get the contents of each trailer file and append to its corresponding detail file. Then delete all the trailer files eg.
Detail File: "MyDetailFile.TXT_01-02-2002"
01-02-2002aaaaa23334 JanetBrown female active y D
01-02-2002aaaaa23334 MaryBondfemale active n D
01-02-2002aaaaa23334 JimanJones male active y D
01-02-2002aaaaa23334 LinusWrightmale active n D
Trailer file :"MyTrailerFile.DAT_01-02-2002"
01-01-200201-31-20021 T
Final output for each detail file in the directory should be like this:
MyDetailFile.TXT_01-02-2002
01-02-2002aaaaa23334 janejones female active y D
01-02-2002aaaaa23334 MaryBondfemale active n D
01-02-2002aaaaa23334 janejones male active y D
01-02-2002aaaaa23334 MaryBondfemale active n D
01-01-200201-31-20021 T
Anyone who can help with this I will greatly appreciate....Thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a folder called {homedata}
Within this folder there are 12 subfolders 200601.......200612
Within each subfolder there are 8 sets of files
Each filename commences with A B C D E F G or H,
so {filename}* can be used.
I am trying to write a script which will from the top level
go... (1 Reply)
Discussion started by: grinder182533
1 Replies
2. Shell Programming and Scripting
Please let me know.. How to manipulate the data from two files..?
I have two files, file1 has two columns one is variable and second is description. file2 has five columns first column is variable and last one is description..Appreciate the help
I need to overwrite the description from file1... (5 Replies)
Discussion started by: ddk2oo5
5 Replies
3. Shell Programming and Scripting
Hello,
I have mysql binary file which logs all the database queries and i to insert all queries log in to database. First i coverted binary file to text file. and start playing with it. Text file contains following queries, some samples are,
SET INSERT_ID=1;
INSERT INTO test... (0 Replies)
Discussion started by: mirfan
0 Replies
4. Shell Programming and Scripting
I don't know if this is a big issue or not, but I'm having difficulties. I apoligize for the upcoming essay :o.
I'm writing a script, similar to a paint program that edits images, but in the form of ANSI block characters. The program so far is working. I managed to save the image into a file,... (14 Replies)
Discussion started by: tinman47
14 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I am looking for an awk script which should help me to meet the following requirement:
File1 has records in following format
INF: FAILEd RECORD AB1234
INF: FAILEd RECORD PQ1145
INF: FAILEd RECORD AB3215
INF: FAILEd RECORD AB6114
............................ (2 Replies)
Discussion started by: mintu41
2 Replies
6. UNIX for Dummies Questions & Answers
Hi all!
my first post here, so mods -- if this should ideally be in the scripts section, please move there. Thanks!
I have data in the following format:
key1:value1 key2:value2 key3:value3
A
B
C
D
key1:value4 key2:value5 key3:value6
A1
B1
key1: ...
and so on
I want an output... (2 Replies)
Discussion started by: gnat01
2 Replies
7. Shell Programming and Scripting
Hi ,
I have a simple text file with contents as below:
12345678900 971,76 4234560890
22345678900 5971,72 5234560990
32345678900 71,12 6234560190
the new csv-file should be like:
Column1;Column2;Column3;Column4;Column5
123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies
8. Shell Programming and Scripting
Y,T,,H05,6,6,0,0 -> TH05_6
D,5,BT,B -> BT_KIOSK
P,KQC222 -> KQC222
G,B,2 -> BRANI_GATE_2
fileA
TPM658 Y,T,,H05,6,6,0,0
TPM110 D,5,BT,B
TPM136 P,KQC222
TPM180 P,BQC913
TPM575 Y,B,,T05,14,14,0,0
IPM760 G,B,2
TPM011
I need to use second column
$1,$2,$3,$4.....
if first char... (6 Replies)
Discussion started by: ment0smintz
6 Replies
9. Shell Programming and Scripting
Hi,
I am confused how to proceed firther please find the problem below:
Input Files:
DCIA_GEOG_DATA_OCEAN.TXT
DCIA_GEOG_DATA_MCRO.TXT
DCIA_GEOG_DATA_CVAS.TXT
DCIA_GEOG_DATA_MCR.TXT
Output File Name: MMA_RFC_GEOG_NAM_DIM_LOD.txt
Sample Record(DCIA_GEOG_DATA_OCEAN.TXT):(Layout same for... (4 Replies)
Discussion started by: Arun Mishra
4 Replies
10. Shell Programming and Scripting
Hi,
I have a file about 100 lines. Each line is about 2000 characters (each line is fixed length). In middle of each line is following constant value
0000040029892586
Now, I want to go through each line and increment by 1.
So, line 1 will have 586
line 2 will have 587, line 3 will have... (4 Replies)
Discussion started by: jakSun8
4 Replies
LEARN ABOUT DEBIAN
pvm_setrbuf
SETRBUF(3PVM) PVM Version 3.4 SETRBUF(3PVM)
NAME
pvm_setrbuf - Switches the active receive buffer and saves the previous buffer.
SYNOPSIS
C int oldbuf = pvm_setrbuf( int bufid )
Fortran call pvmfsetrbuf( bufid, oldbuf )
PARAMETERS
bufid Integer specifying the message buffer identifier for the new active receive buffer.
oldbuf Integer returning the message buffer identifier for the previous active receive buffer.
DESCRIPTION
The routine pvm_setrbuf switches the active receive buffer to bufid and saves the previous active receive buffer oldbuf. If bufid is set
to 0 then the present active receive buffer is saved and no active receive buffer exists.
A successful receive automatically creates a new active receive buffer. If a previous receive has not been unpacked and needs to be saved
for later, then the previous bufid can be saved and reset later to the active buffer for unpacking.
The routine is required when managing multiple message buffers. For example switching back and forth between two buffers. One buffer
could be used to send information to a graphical interface while a second buffer could be used send data to other tasks in the application.
EXAMPLES
C:
rbuf1 = pvm_setrbuf( rbuf2 );
Fortran:
CALL PVMFSETRBUF( NEWBUF, OLDBUF )
ERRORS
These error conditions can be returned by pvm_setrbuf
PvmBadParam
giving an invalid bufid.
PvmNoSuchBuf
switching to a non-existent message buffer.
SEE ALSO
pvm_setsbuf(3PVM)
30 August, 1993 SETRBUF(3PVM)