05-11-2009
Hi All,
Thanks for your help. I am using following code and its working fine.
awk -F";" '{ print >> "file"_$1}' Testfile.txt
for i in `ls file*`
do
awk '/^HEADER/ {print $0 }' Testfile.txt > ${i}"_CHANGED"
cat $i >> ${i}"_CHANGED"
awk '/^TRAILER/ {print $0 }' Testfile.txt >> ${i}"_CHANGED"
echo "\n" >> ${i}"_CHANGED"
done
rm *DFHDR* *DFTLR*
Thanks.
10 More Discussions You Might Find Interesting
1. Programming
I am trying to compile the pro*C file but gives errors. It says it encountered "std" while it was expecting ; , = ( $ $ORACLE_HOME/bin/proc tradewind/dataaccess/Blob.pcc
Pro*C/C++: Release 10.2.0.3.0 - Production on Fri May 9 11:10:54 2008
Copyright (c) 1982, 2005, Oracle. All rights... (0 Replies)
Discussion started by: shafi2all
0 Replies
2. Shell Programming and Scripting
Hi All,
The following is the scenario
id name
--------------
1 William;Johnson
2 Azim;Abdul
3 Grasim
.
.
etc....
I need the following output
id name
--------------
1 William
1 Johnson
2 Azim (2 Replies)
Discussion started by: kottursamy
2 Replies
3. Shell Programming and Scripting
hi guys, today i'm stuck in a new problem.
the title explain more or less but a particular had been omitted. So i'm going to describe below the situation with an example.
I have different html files and each of them have a consecutive lines group inside that i want to extract.
example:
... (8 Replies)
Discussion started by: sbobotex
8 Replies
4. Shell Programming and Scripting
I have a directory with several hundred files.
The file format is a space delimited row with an unknown number of columns:
A B C D E F G ...
I need to turn this format
File1 A
File1 B
File2 A
File3 A
File3 B
File3 C
...
I can use grep to display the filename next to each row of... (2 Replies)
Discussion started by: newreverie
2 Replies
5. Shell Programming and Scripting
Hi. How can I read row number from one file and print that corresponding record present at that row in another file.
eg
file1
1
3
5
7
9
file2
11111
22222
33333
44444
55555
66666
77777
88888
99999 (3 Replies)
Discussion started by: Abhiraj Singh
3 Replies
6. Shell Programming and Scripting
this is the requirement
list.txt
table1
table2
table3
testfile.txt
name#place#data#select * from table1
name2#place2#data2#select * from table 10 innerjoin table3
name2#place2#data2#select * from table 10
output
name place table1
name2 place table3
i tried using awk (7 Replies)
Discussion started by: vamsekumar
7 Replies
7. Shell Programming and Scripting
I have a file which looks something as following, I would like to split to several files, The start and end of each file is 'FILE' and end with 'ASCII... ' .
At the same time for each file in the first column add 100 and also second column add 100 the rest of the column as it is , see example of... (2 Replies)
Discussion started by: tk2000
2 Replies
8. Shell Programming and Scripting
HI Guys,
I have Below Input :-
RepigA_hteis522 ReptCfiEtrBsCll_aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
RepigA ReptCfiEtrBsCll
hteis522 aofe
MSL04_MSL2_A25_1A 0 9
MSL04_MSL2_A25_1B 0 9
MSL04_MSL2_A25_1C 0 9
Split Data in two first row... (2 Replies)
Discussion started by: pareshkp
2 Replies
9. UNIX for Beginners Questions & Answers
My original files are like this below and I distinguish them from the AP_ID (file1 has 572 and file2 has 544). Also, the header on file1 has “G_” pre-pended. NOTE: these are only snippets of very large files and much of the data is not present here.
Original File 1:
... (36 Replies)
Discussion started by: aachave1
36 Replies
10. UNIX for Beginners Questions & Answers
This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6).
The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies
LEARN ABOUT PHP
cubrid_lob2_read
CUBRID_LOB2_READ(3) 1 CUBRID_LOB2_READ(3)
cubrid_lob2_read - Read from BLOB/CLOB data.
SYNOPSIS
string cubrid_lob2_read (resource $lob_identifier, int $len)
DESCRIPTION
The cubrid_lob2_read(3) function reads $len bytes from the LOB data and returns the bytes read.
PARAMETERS
o $lob_identifier
-Lob identifier as a result of cubrid_lob2_new(3) or get from the result set.
o $len
-Length from buffer you want to read from the lob data.
RETURN VALUES
Returns the contents as a string.
FALSE when there is no more data.
NULL on failure.
EXAMPLES
Example #1
cubrid_lob2_read(3) example 1
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "public", "");
$req = cubrid_execute($conn, "select * from test_lob");
$row = cubrid_fetch_row($req, CUBRID_LOB);
print "position now is " . cubrid_lob2_tell($row[1]) . "
";
cubrid_lob2_seek($row[1], 10, CUBRID_CURSOR_FIRST);
print "
position after moving farword is " . cubrid_lob2_tell($row[1]) . "
";
$data = cubrid_lob2_read($row[1], 12);
print "
position after reading is " . cubrid_lob2_tell($row[1]) . "
";
print $data . "
";
cubrid_lob2_seek($row[1], 5, CUBRID_CURSOR_CURRENT);
print "
position after moving again is " . cubrid_lob2_tell($row[1]) . "
";
$data = cubrid_lob2_read($row[1], 20);
print $data . "
";
cubrid_disconnect($conn);
?>
Example #2
cubrid_lob2_read(3) example 2
<?php
// test_lob (id INT, contents CLOB)
$conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
$req = cubrid_execute($conn, "select * from test_lob");
$row = cubrid_fetch_row($req, CUBRID_LOB);
while (true) {
if ($data = cubrid_lob2_read($row[1], 1024)) {
print $data . "
";
}
elseif ($data === false) {
print "There is no more data
";
break;
}
else {
print "There must some errors
";
break;
}
}
cubrid_disconnect($conn);
?>
SEE ALSO
cubrid_lob2_write(3), cubrid_lob2_seek(3), cubrid_lob2_seek64(3), cubrid_lob2_tell(3), cubrid_lob2_tell64(3), cubrid_lob2_size(3),
cubrid_lob2_size64(3).
PHP Documentation Group CUBRID_LOB2_READ(3)