how to implement in one-line awk in a fixed file having no delimiter Post: 302488619

Sponsored Content

Top Forums Shell Programming and Scripting how to implement in one-line awk in a fixed file having no delimiter Post 302488619 by millan on Tuesday 18th of January 2011 02:17:15 AM

01-18-2011

Registered User

how to implement in one-line awk in a fixed file having no delimiter

Hi,

I have a file a.txt having no delimiter.
I want to exclude the line which contains 435th character as 1 or 2 and redirect the rest of the lines to another file b.
Can you pls suggest how to do this in one liner awk.

Following is just one line of the input file a:-

Code:

120110116                                000001000000000001200000.00USD0000000001.2000135058492000094000000.00PL 000.150000B  000000000000.00   0105.00000.000
0002011011820110121MODE0               D4028                  27385       JP31368000044028 6466866          FJT140280               COMNIVBIHARA SANGYO Y50
             JPY                                     ABC000000000000.00Eabcdend                                                              VICVBERTTN0093.000
053.000000.00                20110118      05:57:31      000.00000010185450    TFLOW    NBD   NNF    CHASNEAB MODFAN CHABD CDBV as agdnt (NE180 ESCROW)
                             UTCHBS
                                                                                                                ABC.BADKS NMRSJPJT                 AD-SD5213
                                                                                                                       NIMIPA
                                                                    ABC.BCDSS MHCBJPJ2                 0000380
                                                                           MIZUHO                                            000.150000000001200000.0000000100
0000  VICKRRTT                         NNNN                                     NNN000000000000.00N0000N                               00         000000000000
.00                                                                                                                                                0000000000.
0000000000000001000000                           000.000000000.000000000.000000000000000000.00000000000000.00000000000000.00         000000000000.00 000000000
0.000000000000000000.00000000000000.000000000000.000000000000000000.00000000000000.00000000000000.00000000000000.00000000000000.0020110121000000000000.00Y0000
01136432.33              NY10185450        N0900080.00
                                                                                                0000000001.20000000000000000.0000000T000000000000.000000010000
00.00000001000000.00000001000000.00ABC                                            0100.00                     0000000000

Last edited by Franklin52; 01-18-2011 at 03:20 AM.. Reason: Please use code tags

millan

View Public Profile for millan

Find all posts by millan

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

adding delimiter to a fixed width file

Hi , I have a file : CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74100.00 CSCH74000.00 CSCH74000.00 CSCH74100.00 CSCH74100.00 CSCH74100.00 I have to put a delimiter( say comma) in between after 6th character: CSCH74,000.00 CSCH74,000.00 CSCH74,100.00

2. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

Source File: abcdefghijklmnop01qrstuvwxyz abcdefghijklmnop02qrstuvwxyz abcdefghijklmnop03qrstuvwxyz abcdefghijklmnop04qrstuvwxyz abcdefghijklmnop05qrstuvwxyz Whatever characters are in 17-18 on each line of the file, it should be concatenated to the same line at the character number...

3. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Hi Can somebody help me with solution for this PLEASE? I have a flat file and need to insert delimiters at fixed positions in all the lines so that I can easily convert into EXCEL with columns defined as per their width. For Example Here is the file { kkjhdhal sdfewss sdtereetyw...

4. Shell Programming and Scripting

search for a string without fixed delimiter in the line

Hi Need your help to assign the string to a variable from a line which has no fixed delimter in unix. for example , my file contains Name="report"" File Name one="test1" File Name two="test2" now how do I read report , test1 and test2 ? var1=report var2=test1 var3=test2 ...

5. Shell Programming and Scripting

Implement in one line sed or awk having no delimiter and file size is huge

I have file which contains around 5000 lines. The lines are fixed legth but having no delimiter.Each line line contains nearly 3000 characters. I want to delete the lines a> if it starts with 1 and if 576th postion is a digit i,e 0-9 or b> if it starts with 0 or 9(i,e header and footer) ...

6. Shell Programming and Scripting

Need next line as a space delimiter in awk

Hi,Below is the output for p3fi_dev services 1/app/oracle> . ./oraprofile_p3fi_dev p3fi_dev_01 (P):/devoragridcn_01/app/oracle> srvctl config service -d p3fi_dev p3fi_p3fi_dev.world PREF: p3fi_dev_01 AVAIL: p3fi_dev_02 pplnet_p3fidev PREF: p3fi_dev_01 AVAIL: p3fi_dev_02 nexus_p3fidev PREF:...

7. Shell Programming and Scripting

Adding delimiter to a fixed pattern of date

I have a text file as below: jan16201413:17PM jan1620143:17PM jan1620143:17PM jan1620143:17PM jan1620143:17PM I want to add a delimeter which will be space to the date part as below: jan 16 2014 13:17 PM jan 16 2014 3:17 PM jan 16 2014 3:17 PM jan 16 2014 3:17 PM jan 16...

8. Red Hat

Converting fixed width file to pipe delimiter in Linux(red-hat)

Hi, I am facing a typical scenario for AWK command . In HP- UNIX is behave as expected but in red hat linux same awk code is not give the same result. The below code is for convert the fixed width file to pipe delimiter file in HP-unix server. awk code: #!/bin/awk -f NR!=1...

9. Shell Programming and Scripting

Join the line on delimiter using sed/awk in UNIX

I've input as , abcd| ef 123456| 78| 90 Desired output as, abcdef 1234567890 Anyone please give the solution.

10. Shell Programming and Scripting

awk issue splitting a fixed-width file containing line feed in data

Hi Forum. I have the following script that splits a large fixed-width file into smaller multiple fixed-width files based on input segment type. The main command in the script is: awk -v search_col_pos=$search_col_pos -v search_str_len=$search_str_len -v segment_type="$segment_type"...

LEARN ABOUT PLAN9

regexp

REGEXP(6)							   Games Manual 							 REGEXP(6)

NAME

       regexp - regular expression notation

DESCRIPTION

       A  regular  expression  specifies  a  set  of  strings of characters.  A member of this set of strings is said to be matched by the regular
       expression.  In many applications a delimiter character, commonly bounds a regular expression.  In the following specification for  regular
       expressions the word `character' means any character (rune) but newline.

       The syntax for a regular expression e0 is

	      e3:  literal | charclass | '.' | '^' | '$' | '(' e0 ')'

	      e2:  e3
		|  e2 REP

	      REP: '*' | '+' | '?'

	      e1:  e2
		|  e1 e2

	      e0:  e1
		|  e0 '|' e1

       A literal is any non-metacharacter, or a metacharacter (one of .*+?[]()|^$), or the delimiter preceded by

       A  charclass  is  a  nonempty string s bracketed [s] (or [^s]); it matches any character in (or not in) s.  A negated character class never
       matches newline.  A substring a-b, with a and b in ascending order, stands for the inclusive range of characters between a and  b.   In	s,
       the  metacharacters  an initial and the regular expression delimiter must be preceded by a other metacharacters have no special meaning and
       may appear unescaped.

       A matches any character.

       A matches the beginning of a line; matches the end of the line.

       The REP operators match zero or more (*), one or more (+), zero or one (?), instances respectively of the preceding regular expression e2.

       A concatenated regular expression, e1e2, matches a match to e1 followed by a match to e2.

       An alternative regular expression, e0|e1, matches either a match to e0 or a match to e1.

       A match to any part of a regular expression extends as far as possible without preventing a match to the remainder of the  regular  expres-
       sion.

SEE ALSO

       awk(1), ed(1), sam(1), sed(1), regexp(2)

																	 REGEXP(6)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

adding delimiter to a fixed width file

Discussion started by: sumeet

2. Shell Programming and Scripting

Appending string (charachters inside the line) to a fixed width file using awk or sed

Discussion started by: tamahomekarasu

3. UNIX for Advanced & Expert Users

Insert Delimiter at fixed locations in a flat file

Discussion started by: jd_mca

4. Shell Programming and Scripting

search for a string without fixed delimiter in the line

Discussion started by: rashmisb