08-06-2009
search and replace fixed length record file
Hi
I need to be search a file of fixed length records and when I hit a particular record that match a search string, substitute a known position field
In the example file below
FHEAD000000000120090806143011
THEAD0000000002Y0000000012 P00000000000000001234
TTAIL0000000003
THEAD0000000004Y0000000044 N00000000000000001299
TTAIL0000000005
I need to only consider the THEAD records and swap the Ps to Ns, and visa versa, in position 40,
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello!
I have a file with fixed record length...
format:
123445asdfg 4343777 sfgg
I wanna convert it to
123445,asdfg ,4343,777 ,sfgg
is there any way to do it?
sed/grep/awk??
at the moment I use sed -e 's_ \(\)_,\1_g'
but it works only if there are spaces between... (16 Replies)
Discussion started by: george_
16 Replies
2. Shell Programming and Scripting
$ cat template
s.noName
$ sed "s/s.no/1/" template > out
$ sed "s/s.no/100/" template >>out
$ cat out
1Name
100Name
1 Name
100Name (7 Replies)
Discussion started by: McLan
7 Replies
3. UNIX for Dummies Questions & Answers
I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies
4. Shell Programming and Scripting
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies
5. Shell Programming and Scripting
Masters,
I have fixed length input file like FHEAD0000000001XXXX20090901 0000009000Y1000XXX2
THEAD000000000220090901 ITM0000109393813 430143504352N22SP 000000000000RN000000010000EA P0000000000000014390020090901
TTAIL0000000003000000
FTAIL00000000040000000002
Note... (4 Replies)
Discussion started by: bittoo
4 Replies
6. Shell Programming and Scripting
I am new to awk and writing a script using awk. I have file containing fixed length records, I wish to extract 2 substring(each substring is padded with zeros on left e.g 000000003623) and add each substring respectively for every record in the file to get total sum of respective substring for all... (5 Replies)
Discussion started by: Devesh5683
5 Replies
7. Shell Programming and Scripting
Hello All,
I working on ksh. I am using fixed length file. My file is like:
========
IXTTIV110827 NANTH AM IKSHIT
ABCDEF 0617 IJAY NAND EENIG
ZXYWVU 0912 AP OOK OONG
PQRSTU100923 NASA DISH TTY
ASDFG 0223 GHU UMA LAM
QWERT 0111 ATHE SH THEW
=======
From 7th to 12 is a date... (4 Replies)
Discussion started by: AnanthaDikshit
4 Replies
8. Shell Programming and Scripting
Hi Everyone,
I need to increment a value in the fixed length file. The file has almost a million rows. Is there any easy way to accomplish this.
Ex
input file
ASDSD ADSD 00000 X
AAASD ADSD 00000 X
SDDDD ADSD 00000 X
Ouput
ASDSD ADSD 00001 X
AAASD ADSD 00002 X
SDDDD ADSD 00003 X
... (7 Replies)
Discussion started by: saratha14
7 Replies
9. Shell Programming and Scripting
Hi Team,
I have an issue to split the file which is having special chracter(German Char) using awk command.
I have a different length records in a file. I am separating the files based on the length using awk command.
The command is working fine if the record is not having any... (7 Replies)
Discussion started by: Anthuvan
7 Replies
10. Shell Programming and Scripting
Hi Forum.
I tried searching for a solution using the internet search but I haven't been able to find any solution for what I'm trying to accomplish.
I have a fixed width column file where I need to search for any occurrences of "D0" in col pos.#1-2, 10-11, 20-21 and replaced it with "XD".
... (2 Replies)
Discussion started by: pchang
2 Replies
LEARN ABOUT DEBIAN
mdbfontset
mdbFontset(5) The m17n Library mdbFontset(5)
NAME
mdbFontset - Fontset
DESCRIPTION
The m17n library loads a fontset definition from the m17n database by the tags <fontset, FONTSET-NAME>. The plist format of the data is as
follows:
FONTSET ::= PER-SCRIPT * PER-CHARSET * FALLBACK *
PER-SCRIPT ::= '(' SCRIPT PER-LANGUAGE + ')'
PER-LANGUAGE ::= '(' LANGUAGE FONT-SPEC-ELEMENT + ')'
PER-CHARSET ::= '(' CHARSET FONT-SPEC-ELEMENT + ')'
FALLBACK ::= FONT-SPEC-ELEMENT
FONT-SPEC-ELEMENT ::= '(' FONT-SPEC [ FLT-NAME ] ')'
FONT-SPEC ::=
'(' [ FOUNDRY FAMILY
[ WEIGHT [ STYLE [ STRETCH [ ADSTYLE ]]]]]
REGISTRY
[ OTF-SPEC ] [ LANG-SPEC ] ')'
SCRIPT is a symbol of script name (e.g. latin, han) or nil. LANGUAGE is a two-letter symbol of language name code defined by ISO 639 (e.g.
ja, zh) or nil.
FONT-SPEC is to specify properties of a font. FOUNDRY to REGISTRY are symbols corresponding to Mfoundry to Mregistry property of a font.
See m17nFont for the meaning of each property.
OTF-SPEC is a symbol specifyng the required OTF features. The symbol name has the following syntax.
OTF-SPEC-NAME ::= ':otf=' SCRIPT LANGSYS ? GSUB-FEATURES ? GPOS-FEATURES ?
SCRIPT ::= SYMBOL
LANGSYS ::= '/' SYMBOL
GSUB-FEATURES ::= '=' FEATURE-LIST ?
GPOS-FEATURES ::= '+' FEATURE-LIST ?
FEATURE-LIST ::= '~' ? FEATURE ( ',' '~' ? FEATURE ',' )
Here, FEATURE is a four-letter Open Type feature.
LANG-SPEC is a symbol specifying the required language support. The symbol name has the following syntax.
LANG-SPEC-NAME ::= ':lang=' LANG
Here, LANG is a two or three-letter ISO-639 language code.
FLT-NAME is a name of Font Layout Table (Font Layout Table).
EXAMPLE
This is an example of PER_SCRIPT.
(han
(ja
((jisx0208.1983-0)))
(zh
((gb2312.1980-0)))
(nil
((big5-0))))
It instructs the font selector to use a font of registry 'jisx0208.1983-0' for a 'han' character (i.e. a character whose Mscript property
is 'han') if the character has Mlanguage text property 'ja' in an M-text and the character is in the repertories of such fonts. Otherwise,
try a font of registry 'gb2312.1980-0' or 'big5-0'. If that 'han' character does not have Mlanguage text property, try all three fonts.
See the function mdraw_text() for the detail of how a font is selected.
COPYRIGHT
Copyright (C) 2001 Information-technology Promotion Agency (IPA)
Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
<http://www.gnu.org/licenses/fdl.html>.
Version 1.6.2 12 Jan 2011 mdbFontset(5)