05-16-2008
how to read record by record from a file in unix
Hi guys,
i have a big file with the following format.This includes header(H),detail(D) and trailer(T) information in the file.My problem is i have to search for the character "6h" at 14 th and 15 th position in all the records .if it is there i have to write all those records into a separate file along with the header and trailer and the last nine digits in the trailer should indiacate the count of the detaied records.can any one help me on this how to achive? Basically i am new to unix shell scripting.
following the file format is
HBM6303000000000200805060940412008050609404120080506SCITS 8.2
D6303200805066HJ8164-61002 EURO6303I0073554514 0017992008031120080430HP00DD00Hewlett-Packard Pte Ltd 12.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022797990001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022797990001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018052008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798050001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798050001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018142008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798140001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798140001
D6303200805066HJ8164-61002 EURO6303I0073554514 0018092008031120080430HP00DD00Hewlett-Packard Pte Ltd 16.000 20080502 0000000509.3900UDNB USDEA 00001EA SG 00022798090001 00000120080226 0073554514 6303 N101 HP00DD00 20080503 00022798090001
TBM630300000000020080506094041000003818
advancedthanks
narasimha.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all
I have file f1 like this:
Set AM/PM indicator to PM started|14155|
Generate Error Re|7|
Projected Cash Ba|741|
Roll System Date |4|
Projected Cash Balances started|2|
Process Mark To Market started|13429|
Process paydowns started|14189|
Process Fixed Inc|439|
Process Mark To... (3 Replies)
Discussion started by: koti_rama
3 Replies
2. Shell Programming and Scripting
Hi,
I am new to UNIX scripting and woiuld appreicate your help...
Input file contains only one (but long) record:
aaaaabbbbbcccccddddd.....
Desired file:
NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant#
aaaaa
bbbbb
ccccc
ddddd
...
...
... (1 Reply)
Discussion started by: rsolap
1 Replies
3. UNIX for Advanced & Expert Users
Hi
I have an xml file which has multiple xml records..
I don't know how to read those records and pipe them to another shell command
the file is like
<abc>z<def>y<ghi>x........</ghi></def></abc> (1st record)
<jkl>z<mno>y<pqr>x........</pqr></mno></jkl> (2nd record)
Each record end... (4 Replies)
Discussion started by: aixjadoo
4 Replies
4. Shell Programming and Scripting
Hi
I want to read one row record from a text file.
For eg: I have Sample.txt file with one row of record like
123456768
I want to get the above value from the file and assign it to a variable in my script. Please guide me how to proceed.
Thanks,
Soll (2 Replies)
Discussion started by: sollins
2 Replies
5. Shell Programming and Scripting
Hi Guys,
I am new to unix scripting and I am tasked to parse through a CSV file delimited by #.
Sample:
sample.csv
H#A#B#C
D#A#B#C
T#A#B#C
H = Header
D = Detail Record
T = Tail
What I need is to read the file and parse through it to get the columns.
I have no idea on how... (8 Replies)
Discussion started by: 3vilwyatt
8 Replies
6. Shell Programming and Scripting
For eg: I have sample.txt file with 4 rows of record like:
user1|password1
user2|password2
user3|password3
user4|password4
The username and password is sepsrated by '|'
I want to get the 1st row value from the file and assign it to two different variables(username and password)
in my... (1 Reply)
Discussion started by: priya001
1 Replies
7. Shell Programming and Scripting
Hi,
I am reading file records inside a while loop,
and want to update the record when certain condition is met.
How can I update a file while being read?
I want to avoid using temporary files, copy, rename, ...
while IFS=',' read -r f1 f2
do
function(f1,f2)
if
then
<add... (1 Reply)
Discussion started by: ysrini
1 Replies
8. Shell Programming and Scripting
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies
9. Shell Programming and Scripting
Hello, I have a file that looks like this:
Generated geometry (...some special descriptor)
1 0.56784 1.45783 -0.87965
8 1.29873 -0.8767 1.098789
... ... ... ...
Generated geometry (....come special descriptor)
... .... ... ...
... ... ... ...
and... (4 Replies)
Discussion started by: jaldo0805
4 Replies
10. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
ENVEXT(1) The Canonical Csound Reference ENVEXT(1)
NAME
envext - Extracts the envelope of a file to a text file. .
SYNTAX
envext [-flags] soundfile
csound -U envext [-flags] soundfile
INITIALIZATION
soundfile - Name of the input soundfile.
The following flags are available for envext (The default values are stated in parenthesis):
-o fnam Name of output filename (newenv)
-w size (in seconds) of analysis window (0.25)
The envext utility generates a text file containing time and amplitude pairs by finding the absolute peak within each window.
EXAMPLE
Using the command (while in the manual directory):
csound -U envext examples/mary.wav
will produce the a text file containing the following:
0.000 0.000
0.000 0.000
0.250 0.000
0.500 0.000
0.750 0.000
1.249 0.170
1.499 0.269
1.530 0.307
1.872 0.263
2.056 0.304
2.294 0.241
2.570 0.216
2.761 0.178
3.077 0.011
3.251 0.001
3.500 0.000
Which shows the time for the peak amplitude within each measured window.
CREDITS
Author: John ffitch
1995
AUTHORS
Barry Vercoe
MIT Media Lab
Author.
Dan Ellis
MIT Media Lab,
Cambridge
Massachussetts
Author.
COPYRIGHT
5.07 06/23/2009 ENVEXT(1)