Deleting Characters at specific position in a line if the line is certain length

Cailet · #1 (**permalink**) 12-15-2008

I've got a file that would have lines similar to:
12345678 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
23456781 x.00 xx.00 xx.00 xx.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
34567812 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
45678123 x.00 xx.00 xx.00 xx.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00 xx.00 xx.00

I'm looking to basically do:

if [ current line > 1208 characters ]
delete characters at position 102-106
delete characters at position 1208-1214
copy modified line to new file
else
copy line as is to new file

so the new file would be:
12345678 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
23456781 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
34567812 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00
45678123 x.00 xx.00 x.00 xxx.00 xx.00 xx.00 xx.00

all lines will start with an 8 digit key
we don't know what the characters we are deleting will be (so no pattern searches)

Right now I've been looking at doing a while read inputline loop and checking the character length of each line with the wc -m command. If -gt 1208 perform corrections and copy to new file.

I wasn't sure if there was an easier way to do this -- and I haven't actually been able to figure out the best way to make the corrections to each individual line.

Any ideas?
Thanks!

vgersh99 · #2 (**permalink**) 12-15-2008

Code:

nawk '
{
   if (length <= 1280) 
     print
   else
     print substr($0, 1, 102) substr($0,106, 1208 -106) substr($0, 1214)
}
' myFile > myNewFile

Cailet · #3 (**permalink**) 12-16-2008

Thanks vgersh99!

I had to change nawk to awk (it was telling me nawk not found) and that seemed to do the trick

Cailet · #4 (**permalink**) 12-16-2008

Ok, just kidding. I don't know what happened the first time, but now it is no longer working. Is this maybe a problem with trying to switch from nawk to awk?

vgersh99 · #5 (**permalink**) 12-16-2008

Quote:

Originally Posted by Cailet

Ok, just kidding. I don't know what happened the first time, but now it is no longer working. Is this maybe a problem with trying to switch from nawk to awk?

maybe...
pls define 'no longer working'. what's happenin'?
do you have 'gawk' available (maybe under /usr/local/bin)?
What OS?

Cailet · #6 (**permalink**) 12-16-2008

I thought it had worked, but I must have had my line numbers mixed up when I checked it.

Right now I have this:

Code:

    awk '{if (length($0) <= 1280) 
            print
          else
            print substr($0, 1, 602) substr($0,610, 1208 -610) substr($0, 1214)
          }' $oldFile > $newFile

It is printing to the new file fine until it gets to the first line which needs to be changed. Then it stops (no error messages).

I did a which gawk command and it says no gawk found

I'm doing some more research myself to see if I can figure it out

OS is Windows XP pro

vgersh99 · #7 (**permalink**) 12-16-2008

Windows XP, eh?

try putting the 'body' of the code code in a separate file - cailet.awk:

cailet.awk:

Code:

{
   if (length($0) <= 1280) 
            print
   else
            print substr($0, 1, 602) substr($0,610, 1208 -610) substr($0, 1214)
}

and execute it like so:

Code:

awk -f cailet.awk $oldFile > $newFile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Break line after last "/" if length > X characters	SportBilly	Shell Programming and Scripting	9	10-25-2008 03:15 PM
sed remove last 10 characters of a line start from 3rd line	minifish	Shell Programming and Scripting	7	03-26-2008 04:42 PM
check position of end of line for some specific lines	senthil_is	Shell Programming and Scripting	1	11-09-2007 01:19 AM
Deleting First Two Characters On Each Line	scotbuff	Shell Programming and Scripting	5	12-16-2006 01:03 AM
Deleting the blank line in a file and counting the characters....	rkumar28	Shell Programming and Scripting	4	04-17-2005 12:13 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: