|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Column wise file parsing.
Post 302282117 by navojit dutta on Friday 30th of January 2009 06:58:04 AM
01-30-2009
Column wise file parsing.
Shell script for the below operation :
File "A" contains :
SEQ++1'
MOA+9:000,00:ABC'
RFF+AIK:000000007'
FII+PH+0170++AA'
NAD+PL+++XXXXXXXXXXX XXXXXXX XX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL'
SEQ++2'
MOA+9:389,47:ABC'
RFF+AIK:02110300000008'
FII+PH+0PSTBNL2A:25:5+BB'
NAD+PL+++************************++********************+++NL'
SEQ++3'
MOA+9:3086,55
DD'
RFF+AIK:00009'
FII+PH+0348932928++GG'
NAD+PL+++XXX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL'
Need to fetch the details from the above file "A" and put them in file "B" in the below format :
payment file | Amount | Ref | Account No
1 9:000,00:ABC' 000000007' 0170++AA
2 9:389,47:ABC' 02110300000008' 0PSTBNL2A:25:5+BB'
The columns can be tab delimited.
I was able to do it in step wise using sed...have anyone done this in this way?
Thanks....
File "A" contains :
SEQ++1'
MOA+9:000,00:ABC'
RFF+AIK:000000007'
FII+PH+0170++AA'
NAD+PL+++XXXXXXXXXXX XXXXXXX XX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL'
SEQ++2'
MOA+9:389,47:ABC'
RFF+AIK:02110300000008'
FII+PH+0PSTBNL2A:25:5+BB'
NAD+PL+++************************++********************+++NL'
SEQ++3'
MOA+9:3086,55
DD'RFF+AIK:00009'
FII+PH+0348932928++GG'
NAD+PL+++XXX++XXX XXXX XXXX X.X. XXXXXXXXX+++NL'
Need to fetch the details from the above file "A" and put them in file "B" in the below format :
payment file | Amount | Ref | Account No
1 9:000,00:ABC' 000000007' 0170++AA
2 9:389,47:ABC' 02110300000008' 0PSTBNL2A:25:5+BB'
The columns can be tab delimited.
I was able to do it in step wise using sed...have anyone done this in this way?
Thanks....
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a m X n matrix written out to file, say like this:
1,2,3,4,5,6
2,6,3,10,34,67
1,45,6,7,8,8
I want to calculate the column averages in the MINIMUM amount of code or processing possible. I would have liked to use my favorite tool, "AWK" but since it processes rowwise, getting the... (5 Replies)
Discussion started by: Abhishek Ghose
5 Replies
2. Shell Programming and Scripting
hi
i have file which hav following entries
1501,AAA,2.00
1525,AAA,2.00
1501,AAA,2.00
1525,AAA,2.00
1501,AAA,3.00
1525,AAA,3.00
1525,AAA,3.00
1501,AAA,3.00
1501,AAA,3.00
i want to have a o/p coloum wise
like
1501,AAA,13
1525,AAA,10
here 13 comes as a sum of last colum value... (6 Replies)
Discussion started by: aaysa123
6 Replies
3. Solaris
Hi,
I have two files. Want to make an addition of the fifth column of from both the files and redirect it to a third file.
Both files have same records except fifth field and same record should be inserted into new file having fifth field as addition of fifth fields of both files.
for... (2 Replies)
Discussion started by: sanjay1979
2 Replies
4. Shell Programming and Scripting
i have a file which has a column that is unique
i am intending to serach it and if it is there to remove the row.
the file looks like
ROLLNO,NAME ,SUB1,SUB2,SUB3,TOTAL,PERCENTAGE,RESULT
15 ,rig ,34 ,56 ,87 ,177 ,59 % ,PASS
23 ,wel ,45 ,76 ,56 ,177 ,59 % ... (0 Replies)
Discussion started by: gotam
0 Replies
5. Shell Programming and Scripting
Scottn, m really sorry but i have not got my answer yet.
my concern is how to delete the row !!!
i have a file which has a column that is unique
i am intending to serach it and if it is there to remove the row.
the file looks like
ROLLNO,NAME ,SUB1,SUB2,SUB3,TOTAL,PERCENTAGE,RESULT... (9 Replies)
Discussion started by: gotam
9 Replies
6. Shell Programming and Scripting
I have a .csv file which is seperated with (;)
inputfile
---------
ZZZZ;AAAA;BBB;CCCC;DDD;EEE;
YYYY;BBBB;CCC;DDDD;EEE;FFF;
...
...
reading file line by line till end of file.
while reading each line output format should be .
i need to print only specific columns let say 5th... (2 Replies)
Discussion started by: rocking77
2 Replies
7. Shell Programming and Scripting
Hi,
I am trying to get the file in particular pattern using shell script. I have to add one column to some other file.
For example consider two file as below.
File1:
name1
name2
name3
File2:
Add1 age1
Add2 age2
Add3 age3
I want this two file in a single file format something like... (3 Replies)
Discussion started by: diehard
3 Replies
8. Red Hat
Suppose I have a file containing :-
1 Apple $50
2 Orange $30
3 Banana $10
4 Guava $25
5 Pine@apple $12
6 Strawberry $21
7 Grapes $12
In the 5th row, @ character inserted. I want through sort command or by any other way this row should either on top or bottom.
By sort command garbage... (1 Reply)
Discussion started by: Dipankar Mitra
1 Replies
9. Shell Programming and Scripting
Hi I have pasted sample data as below:- in data.txt
Please suggest any way out: as the 3rd field is
cat data.txt
22:37:34 STARTING abc
22:37:40 FAILURE sadn
00:06:42 STARTING asd
00:06:51 FAILURE ad
02:06:38 STARTING acs
02:06:46 FAILURE cz
04:06:35 STARTING xzc... (1 Reply)
Discussion started by: Gaurav198
1 Replies
10. Shell Programming and Scripting
My below code works fine if none of the columns has pipe as its content in it, If it has the pipe in any of the content then the value moves to the next column.
I wanted my code to work fine even if the column has pipe in it apart from the delimiter.
NOTE : If there is a pipe in the content... (6 Replies)
Discussion started by: nikhil jain
6 Replies
LEARN ABOUT CENTOS
perlko
PERLKO(1) Perl Programmers Reference Guide PERLKO(1) NAME
perlko - PerlXX XXXXXXXX XXXXXXX DESCRIPTION
PerlXXX XXXXXXXX XXXXX XXXXX XXXXXXXXXXXXXX ! PerlXXX 5.8.0XXXXXXXX XXXXXXXXXXX/ISO 10646XXX XXXXXX XXXXXXXXXX XXXXXXXX XXXXXXXX. XXXXXXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXX XXXXX XXXXXXXXXX XXXXXXXXXXX XXXXXXXX XXXXX XXXXXXXX XXXXXXX XXXXX XXXXXXX XXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXXXXX. XXXXXXXXXXXXXX XXX XXXXXXXXXXX XXXXXXX XXXX XXXXXXX XXXXXX XXXXX XXXX - XXXXXXXX XXXXX XXXXXXXX, XXXX XXXXXXXX, XXXXXX XXXXXXXX, XXXXXXXX XXXXXX XXXXXXXXXXXX XXXXXXX XXXXX XXXXXXXXX, XXXXXX XXXX, XXXXXXX XXXX, XXXXXXXXXX XXXXXX, XXXXXXXXXX XXXXX, XXXXXXXXX XXXXX, XXXX XXXXXXXXXXX XXXXX XXXX XXX- XX XXXXXXXXXXX XXXXX XXXXXX XXXXX XXXXX XXXXXXX XXXXXX XXXXXXX XX XXXXX XX XXXX XXXXX XXXXX XXXXXXX XXXXXXXX XXXX XXXXXX XXXXXXXXXX XXX XXX XXXXXX XXXX XXXXXXXX XXXXXXXXX XXX XXXX XXXXXXXXXX XXXXXXXXXX XXXXX XXXXXX XXXXX XXXXX XXXXXXX XXXXXXXXX XXXXXXXXXXX. PerlXXX XXXXXXXXXXXXX XXXXXXXXXXXXX XXXX XXXXXXXXX XXXXXX XXXXXXXXXXXX. XXXX XXXXXXXXXXX XXXXXXX Perl XXXXXXXXX XXXXXXXXX UTF-8 XXXXXXXXX XXX XXX XXXXX, XXXX XXXXXXXX XXXXXXX(XXXXX XXXXX, XXXXXXXX, index, substr)XX XXXXXXX XXXXX XXXXXX XXXXXXXXXXX XXXXX XXXXXXX XXXXXXXXXXXXXX. (XXX XXXXXXXX XXXXX perlunicode XXXXXXXX XXXXXXXXXXXXXXXX.) XXXXXXXXXXXXX XXXXX XXXXXXXXX XXXXXX XXXXX XXXXXXX XXXXXXXX, XXXXXXXX XXXXX XXXXXXX XXXXXX XXXX/XX XXXXXXX XXXXXXXXXXXX XXXXXXXXXX XXXXX XXXXX XXXXXXXXXXXX XXX XXXXXXXXX XXXXXX XXXXXXX XXXXX XXXXX XXXXX 'Encode'XX XXXXXXXXXXXXX. XXXXXXXX 'Encode'XX XXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXXXXX XXXXX XXX XXX XXXXXXXXXXX. 'Encode'XXX XXXXXXX XXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXXXXXX. euc-kr US-ASCIIXXX KS X 1001XXX XXXXX XXXXX XXXXXXXXXXXX XXXXXXXX (XXXXXX XXXXXXXXXXXXXXX XXXX.) KS X 2901XX RFC 1557 XXXX. cp949 MS-Windows 9x/MEXXXXXX XXXXXXX XXXXXX XXXXXXXX. euc-krXXX 8,822XXXXXX XXXXX XXXXXXXXX XXXXXX XXXXX. aliasXXX uhc, windows-949, x-windows-949, ks_c_5601-1987. XX XXXXXX XXXXXXXX XXXXXXXXXXX XXXXXX XXXXXXXXXXXX, Microsoft XXXXXXXXXXXX CP949XXX XXXXXXX XXXXXXX XXXXXX. johab KS X 1001:1998 XXXX 3XXXXXX XXXXXXXX XXXXXX. XXXX XXXXXXXXXXXX cp949XXX XXXXXXXXXX US-ASCIIXXX KS X 1001XXX 8,822XXXXXX XXXXX XXXXXXXXX XXXXXX XXXXX. XXXXXXXX XXXXXXX XXXXXX XXXXX. iso-2022-kr RFC 1557XXXXXX XXXXXXXX XXXXXXXX XXXXXXX XXXXX XXXXXXXX XXXXXXXXXXXX US-ASCIIXXX KS X 1001XXX XXXXXXXXXXXX XXXXXX XXXXXXXXX euc-krXX XXXXXX XXXXXXXX XXXXXXX XXXXX. 1997-8XXX XXXXXX XXXXXXXXXX XXX XXXXX XXXXX XXXXXXXX XXXXXXX XXXXXX. ksc5601-raw KS X 1001(KS C 5601)XXX GL(XX, MSBXX 0XXXXX XXX XXXX) XXX XXXXXXXXX XXXXXX XXXXXXXX. US-ASCIIXXX XXXXXXXX XXXXX XXXXXXXXXX XXXXXXX XXXXX X11 XXXXXXXX XXX XXXXXXXX (ksc5601.1987-0. '0'XXX GLXXX XXXXXXX.)XXXXX XXXXXXX XXXXX XXXXXXXXXXXXX XXXX XXXXXX. KS C 5601XXX 1997XXX KS X 1001XX XXXXXXXX XXXXXXXXX. 1998XXXXXXXXX XXX XXXXX (XXXXXXXX XXXXXXX XXXXX XXXXXX XXXXX)XX XXXXXXXXXXX. XX XXXX XXXXX XXXXXXXX XXXXXXXXX XXXXXXXXXX. XXXXX XXXXX, euc-kr XXXXXXXXXXXX XXX XXXXXXXX UTF-8XX XXXXXXXXXXXX XXXXXX XXXXX XXXXX XXXXXXXX. perl -Mencoding=euc-kr,STDOUT,utf8 -pe1 < file.euckr > file.utf8 XXXXXXXXXXX XXXXXXX XXXXX XXX XXX XXXXXXXXXXX. perl -Mencoding=utf8,STDOUT,euc-kr -pe1 < file.utf8 > file.euckr XXXXX XXXXXXXX XXXXX XXXXXXXXX XXX XXX XXXXXXXX Encode XXXXXXX XXXXX XXXXXXXXXXX PerlXXXX XXXXX piconvXX PerlXXX XXXXX XXXXXXXXXXX. XX XXXXXXXXXXX XXX XXX XXXXXXXXX piconvXXX UnixXXX XXXXXX iconvX XXXXXX XXX XXXXXXXXXXX. XX XXXXXXXXXX XXXXXXXXX XXXXXXXXXX. piconv -f euc-kr -t utf8 < file.euckr > file.utf8 piconv -f utf8 -t euc-kr < file.utf8 > file.euckr XXX, 'PerlIO::encoding' XXXXXXX XXXXX XXXXXXXX XXXXXXXXXX XXXXXXX XXXXX XXXXX (XXXXXXX XXXXXXX XXXXXXXXX) XXXXXX XXXXX XXX XXX XXXXXXXXXXX. #!/path/to/perl use encoding 'euc-kr', STDIN => 'euc-kr', STDOUT-> 'euc-kr', STDERR=>'euc-kr'; print length("XXXXX"); # 2 (XXX XXXXXXXXXX XXXXX XXXXX XXXXXX XXXXX) print length('XXXXX'); # 4 (XXXXXX XXXXXXXXXX XXXXXXX XXXXX XXXXXX XXXXX) print index("XXXXX, XXXXXXXX", "XXX"); # -1 ('XXX'XXX XXXXXX) print index('XXXXX, XXXXXXXX', 'XXX'); # 7 (8XXXXXX 9XXXX XXXXXXXXX 'XXX'XXX XXXXXXXXX XXXXXXXX.) XXX XXXXXXXX XXXXX XXXXXX... PerlXXX XXXXXXXXXX XXXXXXXX XXXXXXXX XXXXXX XXXXX XXXXX XXXX, XXX XXXXXX XXXX Perl XXXXX XX XXXXXXXXX XXXXXXXXXXX XXXXX, EncodeXXX XXXXXXX XXXXX XXXXX XXXXX XXXX XXX XXXXXXXXXXX. XXXXX XXX XXXXXXX XXXXXX XXXX XXXXXXXX XXXXX XXXXXXXXXXX. Perl XXXXX XXXXX XXXXXXXXX XXXXXXXX XXXX XXXXXXXX XXXXXXX XXXXX XXXXXXX XXXXXXXXXXX. XXX XXXXXXX XXXX XXXXXXXXX XXXXX XXXXXXXX XXXXX XXXXXXXXXXXX XXXX XXXX XXXXXXXXXXX. <http://www.perl.com/> O'ReillyXXX Perl XXX XXXXXXXX <http://www.cpan.org/> Comprehensive Perl Archive Network <http://lists.perl.org/> Perl XXXXXXX XXXXXX. XXXXX XXXXXX XXXXXX perl-unicodeXXXXXX 'Encode'XXX XXXXXX XXXXXXXX. PerlXXX XXX XXXX XXXXXXXXXXXXX XXXXXXXXX XX XXX XXXXXX XXXXXXXX XXXXX XXXXXX <http://www.perl.or.kr/> Perl XXXXX XXXXXXX XXXX <news:han.comp.lang.perl/> XXXXXXXX Perl XXXXX XXX <http://www.hanb.co.kr/search/searchResult.html?keyword=perl> O'ReillyXXXXXX XXXXXX XXXXXXXX Perl XXXXXX XXXX <http://www.perlschool.net/> Perl XXXX XXXX XX XXXXXX, XXXX XXXXXX, XXXXX XXXXX XXXXXXX XXXXX <http://www.perl.co.kr> PerlXXX XXXXXXX CGI, DB, XXXXX XXXXX XXXXXX XXXXX XX XXXXX XXXX XXXXXXXXXXX XX XXXXXXXX XXXXXXXX XXXXX XXXXX <http://www.unicode.org/> XXXXXXXXXXX XXXXXXXXXX. <http://std.dkuug.dk/JTC1/SC2/WG2> XXXXXXXXXXX UnicodeXXX XXXXX ISO XXXXXXXX ISO/IEC 10646 UCS(Universal Character Set)XXX XXXXXXXX ISO/IEC JTC1/SC2/WG2XXX XXX XXXXXXXX. <http://www.cl.cam.ac.uk/~mgk25/unicode.html> XXXXXXXXX/XXXXXXXXXXXX XXXXXXXXXXXXXX UTF-8 XXXXXXX XXXXXX XXXXXX(FAQ) http://wiki.kldp.org/Translations/html/UTF8-Unicode-KLDP/UTF8-Unicode-KLDP.html <http://wiki.kldp.org/Translations/html/UTF8-Unicode- KLDP/UTF8-Unicode-KLDP.html> XXXXXXXXX/XXXXXXXXXXXX XXXXXXXXXXXXXX UTF-8 XXXXXXX XXXXXX XXXXXX(FAQ)XXX XXXXXXXX XXXXX SEE ALSO
Encode, Encode::KR, encoding, perluniintro, perlunicode AUTHORS
Jarkko Hietaniemi <jhi@iki.fi> XXXXXXXXX <jshin@mailaps.org> perl v5.16.3 2013-03-04 PERLKO(1)