Re: [vox-tech] Changing data with awk

[Mark K. Kim]

Yes, "\n" terminates a record.  But Richard (the original poster) said
that the field has embedded "carriage return" characters, which is "\r".
Since "\r" is not "\n", the codes do work... at least under *NIX.

Yes, pressing the "Enter" key produces carriage return code on a standard
keyboard (ASCII 13 "\r"), but *NIX translates it to the linefeed code
(ASCII 10 "\n"), whereas DOS/Windows translates it to carriage return
followed by linefeed "\r\n", and the older MacOS (before 10) doesn't
translate it at all.  And by convention "\n" under C (along with various
other languages) represents the default line terminator for that platform
("\n" for *NIX, "\r\n" for DOS/Windows, "\r"  under older MacOS.)  But
unlike DOS/Windows, UNIX Lets you turn off the translation using termios.
But now we're off topic... -_-v

-Mark


On Fri, 4 Jun 2004 [EMAIL PROTECTED] wrote:

> Do any of these work?  It seems like all of them will break because
> awk and perl are going to read a record at a time, where the record
> terminator is a \n.  reproducing Richard's original problem
>
> I think in perl you'd have to slurp the whole file (undef $\) then do
> a regex in a loop finding X number of "^"s followed by a "\n"
> memorizing the fields, then substitute the 6th field's "\n"s with
> null, then join the fields back together.
>
> Jay
> - Original Message -
> From: "Mark K. Kim" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 04, 2004 6:24 PM
> Subject: Re: [vox-tech] Changing data with awk
>
>
> > Field separator is not space.  BTW, found a better way:
> >
> >awk -F^ '{OFS="^"; $6=gensub(/\r/,"","",$6); print}' test.dat
> >
> >...mark
> >
> >
> > On Fri, 4 Jun 2004, Leo Rainer wrote:
> >
> > > In awk you can directly modify individual fields so this should work:
> > >
> > >awk -F^ '{$6=gensub(/\r/,"","",$6); print}' test.dat
> > >
> > >  ...leo
> > >
> > > At 03:36 PM 6/4/04, Mark K. Kim wrote:
> > > >Unfortunately that wouldn't work since Richard wants to modify the
> column
> > > >in the file, not strip it out at the same time he modifies it...
> Unless
> > > >you know of some way to re-insert the modified column back into the
> file
> > > >(I don't.)  Good try, though.
> > > >
> > > >I'm not an awk expert but I'd guess you could do something like:
> > > >
> > > >   awk -F^ '{$6=gensub(/\r/,"","",$6);
> > > >printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat
> > > >
> > > >I'm sure someone's got a better idea that putting all those %s's...
> > > >
> > > >-Mark
> > > >
> > > >PS: Then there's PERL... =P
> > > >
> > > >
> > > >On Fri, 4 Jun 2004, Dylan Beaudette wrote:
> > > >
> > > > > > I have a large flat file generated by SQL Loader that I'd like to
> mess
> > > > > > around with; specifically, I'd like to replace all of the carriage
> > > > returns
> > > > > > in one field with some other character, since they're messing up
> my data
> > > > > > load.
> > > > > >
> > > > > > I figured I'd use awk, since it's a pretty powerful little tool
> for
> > > > > > getting right to the data.  If I use:
> > > > > >
> > > > > > $ awk -F^ {print $6} test.dat
> > > > > >
> > > > > > I get the field that I want.  But how do I change the characters
> in that
> > > > > > field and replace them in test.dat?
> > > > >
> > > > >
> > > > > i recently had a similar problem: trying to convert
> > > > > this:
> > > > > 1
> > > > > 2
> > > > > 3
> > > > > ...
> > > > >
> > > > > into this: 1, 2, 3...
> > > > >
> > > > > here is how i did it:
> > > > >
> > > > > append a comma+space to the end of each line with sed
> > > > > then remove each CR using tr:
> > > > >
> > > > > sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
> > > > >
> > > > > so something like this might do the trick:
> > > > >
> > > > > awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" >
> output_file
> > > > >
> > > > >
> > > > > .. you would be left with one column of data that would have to be
> > > > > re-instered into the DB, or added back to the original file.
> > > > >
> > > > > the command 'paste' might be helpful for appending the data to the
> > > > > original...
> > > > >
> > > > >
> > > > > good luck!
> > > > >
> > > > > Dylan
> > > > >
> > > > >
> > > > > ___
> > > > > vox-tech mailing list
> > > > > [EMAIL PROTECTED]
> > > > > http://lists.lugod.org/mailman/listinfo/vox-tech
> > > > >
> > > >
> > > >--
> > > >Mark K. Kim
> > > >AIM: markus kimius
> > > >Homepage: http://www.cbreak.org/
> > > >Xanga: http://www.xanga.com/vindaci
> > > >Friendster: http://www.friendster.com/user.jsp?id=13046
> > > >PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
> > > >PGP key available on the homepage
> > > >___
> > > >vox-tech mailing list
> > > >[EMAIL PROTECTED]
> > > >http://lists.lugod.org/mailman/listinfo/vox-tech
> > >
> > > ___
> > > v

Re: [vox-tech] Changing data with awk

[me]

Do any of these work?  It seems like all of them will break because
awk and perl are going to read a record at a time, where the record
terminator is a \n.  reproducing Richard's original problem

I think in perl you'd have to slurp the whole file (undef $\) then do
a regex in a loop finding X number of "^"s followed by a "\n"
memorizing the fields, then substitute the 6th field's "\n"s with
null, then join the fields back together.

Jay
- Original Message - 
From: "Mark K. Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 04, 2004 6:24 PM
Subject: Re: [vox-tech] Changing data with awk


> Field separator is not space.  BTW, found a better way:
>
>awk -F^ '{OFS="^"; $6=gensub(/\r/,"","",$6); print}' test.dat
>
>...mark
>
>
> On Fri, 4 Jun 2004, Leo Rainer wrote:
>
> > In awk you can directly modify individual fields so this should work:
> >
> >awk -F^ '{$6=gensub(/\r/,"","",$6); print}' test.dat
> >
> >  ...leo
> >
> > At 03:36 PM 6/4/04, Mark K. Kim wrote:
> > >Unfortunately that wouldn't work since Richard wants to modify the
column
> > >in the file, not strip it out at the same time he modifies it...
Unless
> > >you know of some way to re-insert the modified column back into the
file
> > >(I don't.)  Good try, though.
> > >
> > >I'm not an awk expert but I'd guess you could do something like:
> > >
> > >   awk -F^ '{$6=gensub(/\r/,"","",$6);
> > >printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat
> > >
> > >I'm sure someone's got a better idea that putting all those %s's...
> > >
> > >-Mark
> > >
> > >PS: Then there's PERL... =P
> > >
> > >
> > >On Fri, 4 Jun 2004, Dylan Beaudette wrote:
> > >
> > > > > I have a large flat file generated by SQL Loader that I'd like to
mess
> > > > > around with; specifically, I'd like to replace all of the carriage
> > > returns
> > > > > in one field with some other character, since they're messing up
my data
> > > > > load.
> > > > >
> > > > > I figured I'd use awk, since it's a pretty powerful little tool
for
> > > > > getting right to the data.  If I use:
> > > > >
> > > > > $ awk -F^ {print $6} test.dat
> > > > >
> > > > > I get the field that I want.  But how do I change the characters
in that
> > > > > field and replace them in test.dat?
> > > >
> > > >
> > > > i recently had a similar problem: trying to convert
> > > > this:
> > > > 1
> > > > 2
> > > > 3
> > > > ...
> > > >
> > > > into this: 1, 2, 3...
> > > >
> > > > here is how i did it:
> > > >
> > > > append a comma+space to the end of each line with sed
> > > > then remove each CR using tr:
> > > >
> > > > sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
> > > >
> > > > so something like this might do the trick:
> > > >
> > > > awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" >
output_file
> > > >
> > > >
> > > > .. you would be left with one column of data that would have to be
> > > > re-instered into the DB, or added back to the original file.
> > > >
> > > > the command 'paste' might be helpful for appending the data to the
> > > > original...
> > > >
> > > >
> > > > good luck!
> > > >
> > > > Dylan
> > > >
> > > >
> > > > ___
> > > > vox-tech mailing list
> > > > [EMAIL PROTECTED]
> > > > http://lists.lugod.org/mailman/listinfo/vox-tech
> > > >
> > >
> > >--
> > >Mark K. Kim
> > >AIM: markus kimius
> > >Homepage: http://www.cbreak.org/
> > >Xanga: http://www.xanga.com/vindaci
> > >Friendster: http://www.friendster.com/user.jsp?id=13046
> > >PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
> > >PGP key available on the homepage
> > >___
> > >vox-tech mailing list
> > >[EMAIL PROTECTED]
> > >http://lists.lugod.org/mailman/listinfo/vox-tech
> >
> > ___
> > vox-tech mailing list
> > [EMAIL PROTECTED]
> > http://lists.lugod.org/mailman/listinfo/vox-tech
> >
>
> -- 
> Mark K. Kim
> AIM: markus kimius
> Homepage: http://www.cbreak.org/
> Xanga: http://www.xanga.com/vindaci
> Friendster: http://www.friendster.com/user.jsp?id=13046
> PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
> PGP key available on the homepage
> ___
> vox-tech mailing list
> [EMAIL PROTECTED]
> http://lists.lugod.org/mailman/listinfo/vox-tech
>
>

___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Printing under KDE

[Dick Ely]

Thanks Henry:  I will try it tonight. see below:
No they are not new or exotic.  One is a SOYO board and the other is a 
PCI card.  I will go through the documentation tonight. Jonathan has 
volunteered to give me a hand, for which I am grateful.  

Thanks, I will be in touch.  

Dick
Henry House wrote:
På fredag, 04 juni 2004, skrev Richard Ely:
No, localhost:631 is not there.   I know it has been there and working 
because we used cups to print a document the other night.  How do I install 
it?  Probably trashed something trying to get the network to run.

It may be on a different port. Try running 'netstat -lpt' as root and you
will get a listing of all TCP ports that are accepting connections and which
program is listening on each.
What is the relationship between CUPS and printcap file which I do not seem 
to have.  Don't I need that?

CUPS does not use /etc/printcap at all. (That file is part of lpr, lprng,
and other traditional printing systems, which CUPS is not.) However, some
applications expect /etc/printcap to be there and use information from it.
BTW: Response,  Not my idea, the installfest guys were trying to solve a 
network problem which remains.   Are you any good at debugging why two nic 
cards do not seem to work together on a machine?

Are they the same chipset or different chipsets? Are they common cards or
very new/exotic? In that case getting a driver directly from the
manufacturer or from the driver developers may be necessary. What does dmesg
say?
P.S. If you still want help from LERT please don't hesitate to mail
[EMAIL PROTECTED]

___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[Mark K. Kim]

Field separator is not space.  BTW, found a better way:

   awk -F^ '{OFS="^"; $6=gensub(/\r/,"","",$6); print}' test.dat

   ...mark


On Fri, 4 Jun 2004, Leo Rainer wrote:

> In awk you can directly modify individual fields so this should work:
>
>awk -F^ '{$6=gensub(/\r/,"","",$6); print}' test.dat
>
>  ...leo
>
> At 03:36 PM 6/4/04, Mark K. Kim wrote:
> >Unfortunately that wouldn't work since Richard wants to modify the column
> >in the file, not strip it out at the same time he modifies it...  Unless
> >you know of some way to re-insert the modified column back into the file
> >(I don't.)  Good try, though.
> >
> >I'm not an awk expert but I'd guess you could do something like:
> >
> >   awk -F^ '{$6=gensub(/\r/,"","",$6);
> >printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat
> >
> >I'm sure someone's got a better idea that putting all those %s's...
> >
> >-Mark
> >
> >PS: Then there's PERL... =P
> >
> >
> >On Fri, 4 Jun 2004, Dylan Beaudette wrote:
> >
> > > > I have a large flat file generated by SQL Loader that I'd like to mess
> > > > around with; specifically, I'd like to replace all of the carriage
> > returns
> > > > in one field with some other character, since they're messing up my data
> > > > load.
> > > >
> > > > I figured I'd use awk, since it's a pretty powerful little tool for
> > > > getting right to the data.  If I use:
> > > >
> > > > $ awk -F^ {print $6} test.dat
> > > >
> > > > I get the field that I want.  But how do I change the characters in that
> > > > field and replace them in test.dat?
> > >
> > >
> > > i recently had a similar problem: trying to convert
> > > this:
> > > 1
> > > 2
> > > 3
> > > ...
> > >
> > > into this: 1, 2, 3...
> > >
> > > here is how i did it:
> > >
> > > append a comma+space to the end of each line with sed
> > > then remove each CR using tr:
> > >
> > > sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
> > >
> > > so something like this might do the trick:
> > >
> > > awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" > output_file
> > >
> > >
> > > .. you would be left with one column of data that would have to be
> > > re-instered into the DB, or added back to the original file.
> > >
> > > the command 'paste' might be helpful for appending the data to the
> > > original...
> > >
> > >
> > > good luck!
> > >
> > > Dylan
> > >
> > >
> > > ___
> > > vox-tech mailing list
> > > [EMAIL PROTECTED]
> > > http://lists.lugod.org/mailman/listinfo/vox-tech
> > >
> >
> >--
> >Mark K. Kim
> >AIM: markus kimius
> >Homepage: http://www.cbreak.org/
> >Xanga: http://www.xanga.com/vindaci
> >Friendster: http://www.friendster.com/user.jsp?id=13046
> >PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
> >PGP key available on the homepage
> >___
> >vox-tech mailing list
> >[EMAIL PROTECTED]
> >http://lists.lugod.org/mailman/listinfo/vox-tech
>
> ___
> vox-tech mailing list
> [EMAIL PROTECTED]
> http://lists.lugod.org/mailman/listinfo/vox-tech
>

-- 
Mark K. Kim
AIM: markus kimius
Homepage: http://www.cbreak.org/
Xanga: http://www.xanga.com/vindaci
Friendster: http://www.friendster.com/user.jsp?id=13046
PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
PGP key available on the homepage
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[David Hummel]

On Fri, Jun 04, 2004 at 04:05:43PM -0700, Foo Lim wrote:
> 
> Use perl.  =D  You can edit the file in place also:
> 
> perl -p -i -e 's/(some regex)\r(some other regex)/${1}X${2}/' test.dat

Unless you are absolutely sure of what you are doing (or you want to
play around first), I'd use:

perl -pi.bk -e ...
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[Leo Rainer]

In awk you can directly modify individual fields so this should work:
  awk -F^ '{$6=gensub(/\r/,"","",$6); print}' test.dat
...leo
At 03:36 PM 6/4/04, Mark K. Kim wrote:
Unfortunately that wouldn't work since Richard wants to modify the column
in the file, not strip it out at the same time he modifies it...  Unless
you know of some way to re-insert the modified column back into the file
(I don't.)  Good try, though.
I'm not an awk expert but I'd guess you could do something like:
  awk -F^ '{$6=gensub(/\r/,"","",$6);
   printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat
I'm sure someone's got a better idea that putting all those %s's...
-Mark
PS: Then there's PERL... =P
On Fri, 4 Jun 2004, Dylan Beaudette wrote:
> > I have a large flat file generated by SQL Loader that I'd like to mess
> > around with; specifically, I'd like to replace all of the carriage 
returns
> > in one field with some other character, since they're messing up my data
> > load.
> >
> > I figured I'd use awk, since it's a pretty powerful little tool for
> > getting right to the data.  If I use:
> >
> > $ awk -F^ {print $6} test.dat
> >
> > I get the field that I want.  But how do I change the characters in that
> > field and replace them in test.dat?
>
>
> i recently had a similar problem: trying to convert
> this:
> 1
> 2
> 3
> ...
>
> into this: 1, 2, 3...
>
> here is how i did it:
>
> append a comma+space to the end of each line with sed
> then remove each CR using tr:
>
> sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
>
> so something like this might do the trick:
>
> awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" > output_file
>
>
> .. you would be left with one column of data that would have to be
> re-instered into the DB, or added back to the original file.
>
> the command 'paste' might be helpful for appending the data to the
> original...
>
>
> good luck!
>
> Dylan
>
>
> ___
> vox-tech mailing list
> [EMAIL PROTECTED]
> http://lists.lugod.org/mailman/listinfo/vox-tech
>

--
Mark K. Kim
AIM: markus kimius
Homepage: http://www.cbreak.org/
Xanga: http://www.xanga.com/vindaci
Friendster: http://www.friendster.com/user.jsp?id=13046
PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
PGP key available on the homepage
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[Foo Lim]

Use perl.  =D  You can edit the file in place also:

perl -p -i -e 's/(some regex)\r(some other regex)/${1}X${2}/' test.dat

I say use all the tools available to you, & use the right tool for the 
job.

Foo

On Fri, 4 Jun 2004, Mark K. Kim wrote:

> Unfortunately that wouldn't work since Richard wants to modify the column
> in the file, not strip it out at the same time he modifies it...  Unless
> you know of some way to re-insert the modified column back into the file
> (I don't.)  Good try, though.
> 
> I'm not an awk expert but I'd guess you could do something like:
> 
>   awk -F^ '{$6=gensub(/\r/,"","",$6);
>printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat
> 
> I'm sure someone's got a better idea that putting all those %s's...
> 
> -Mark
> 
> PS: Then there's PERL... =P
> 
> 
> On Fri, 4 Jun 2004, Dylan Beaudette wrote:
> 
> > > I have a large flat file generated by SQL Loader that I'd like to mess
> > > around with; specifically, I'd like to replace all of the carriage returns
> > > in one field with some other character, since they're messing up my data
> > > load.
> > >
> > > I figured I'd use awk, since it's a pretty powerful little tool for
> > > getting right to the data.  If I use:
> > >
> > > $ awk -F^ {print $6} test.dat
> > >
> > > I get the field that I want.  But how do I change the characters in that
> > > field and replace them in test.dat?
> >
> >
> > i recently had a similar problem: trying to convert
> > this:
> > 1
> > 2
> > 3
> > ...
> >
> > into this: 1, 2, 3...
> >
> > here is how i did it:
> >
> > append a comma+space to the end of each line with sed
> > then remove each CR using tr:
> >
> > sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
> >
> > so something like this might do the trick:
> >
> > awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" > output_file
> >
> >
> > .. you would be left with one column of data that would have to be
> > re-instered into the DB, or added back to the original file.
> >
> > the command 'paste' might be helpful for appending the data to the
> > original...
> >
> >
> > good luck!
> >
> > Dylan
> >
> >
> > ___
> > vox-tech mailing list
> > [EMAIL PROTECTED]
> > http://lists.lugod.org/mailman/listinfo/vox-tech
> >
> 
> 

___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[Mark K. Kim]

Unfortunately that wouldn't work since Richard wants to modify the column
in the file, not strip it out at the same time he modifies it...  Unless
you know of some way to re-insert the modified column back into the file
(I don't.)  Good try, though.

I'm not an awk expert but I'd guess you could do something like:

  awk -F^ '{$6=gensub(/\r/,"","",$6);
   printf("%s^%s^%s^%s^%s^%s\n",$1,$2,$3,$4,$5,$6)}' test.dat

I'm sure someone's got a better idea that putting all those %s's...

-Mark

PS: Then there's PERL... =P


On Fri, 4 Jun 2004, Dylan Beaudette wrote:

> > I have a large flat file generated by SQL Loader that I'd like to mess
> > around with; specifically, I'd like to replace all of the carriage returns
> > in one field with some other character, since they're messing up my data
> > load.
> >
> > I figured I'd use awk, since it's a pretty powerful little tool for
> > getting right to the data.  If I use:
> >
> > $ awk -F^ {print $6} test.dat
> >
> > I get the field that I want.  But how do I change the characters in that
> > field and replace them in test.dat?
>
>
> i recently had a similar problem: trying to convert
> this:
> 1
> 2
> 3
> ...
>
> into this: 1, 2, 3...
>
> here is how i did it:
>
> append a comma+space to the end of each line with sed
> then remove each CR using tr:
>
> sed -e 's/$/, /g' input_file | tr -d "\n" > output_file
>
> so something like this might do the trick:
>
> awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" > output_file
>
>
> .. you would be left with one column of data that would have to be
> re-instered into the DB, or added back to the original file.
>
> the command 'paste' might be helpful for appending the data to the
> original...
>
>
> good luck!
>
> Dylan
>
>
> ___
> vox-tech mailing list
> [EMAIL PROTECTED]
> http://lists.lugod.org/mailman/listinfo/vox-tech
>

-- 
Mark K. Kim
AIM: markus kimius
Homepage: http://www.cbreak.org/
Xanga: http://www.xanga.com/vindaci
Friendster: http://www.friendster.com/user.jsp?id=13046
PGP key fingerprint: 7324 BACA 53AD E504 A76E  5167 6822 94F0 F298 5DCE
PGP key available on the homepage
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Changing data with awk

[Dylan Beaudette]

> I have a large flat file generated by SQL Loader that I'd like to mess
> around with; specifically, I'd like to replace all of the carriage returns
> in one field with some other character, since they're messing up my data
> load.
>
> I figured I'd use awk, since it's a pretty powerful little tool for
> getting right to the data.  If I use:
>
> $ awk -F^ {print $6} test.dat
>
> I get the field that I want.  But how do I change the characters in that
> field and replace them in test.dat?


i recently had a similar problem: trying to convert
this:
1
2
3
...

into this: 1, 2, 3...

here is how i did it:

append a comma+space to the end of each line with sed
then remove each CR using tr:

sed -e 's/$/, /g' input_file | tr -d "\n" > output_file

so something like this might do the trick:

awk -F^ {print $6} test.dat | sed -e 's/$/, /g' | tr -d "\n" > output_file


.. you would be left with one column of data that would have to be
re-instered into the DB, or added back to the original file.

the command 'paste' might be helpful for appending the data to the
original...


good luck!

Dylan


___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

[vox-tech] Changing data with awk

[Richard Crawford]

I have a large flat file generated by SQL Loader that I'd like to mess
around with; specifically, I'd like to replace all of the carriage returns
in one field with some other character, since they're messing up my data
load.

I figured I'd use awk, since it's a pretty powerful little tool for
getting right to the data.  If I use:

$ awk -F^ {print $6} test.dat

I get the field that I want.  But how do I change the characters in that
field and replace them in test.dat?


-- 
Sláinte,
Richard S. Crawford (AIM: Buffalo2K)
http://www.mossroot.com   http://www.stonegoose.com/catseyeview
"You cannot trust your judgement if your imagination is out of focus." 
--Mark Twain


___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Printing under KDE

[Jonathan Stickel]

I seem to recall at the installfest that his this latest NIC problem had 
something to do with IRQ assignments.  KNOPPIX magically appeared to 
solve this, hence the KNOPPIX install.

At this point, I think Dick would be served best by a new Linux install 
with a standard distro.  I recall that he has tried various versions of 
Debian.  I would be willing to help him install Gentoo at his house. 
Dick:  let me know if you would be up for this.  I could do it Saturday 
for sure.  It might still be good to put in a LERT request for the record.

Regards,
Jonathan
Henry House wrote:
På fredag, 04 juni 2004, skrev Richard Ely:
No, localhost:631 is not there.   I know it has been there and working 
because we used cups to print a document the other night.  How do I install 
it?  Probably trashed something trying to get the network to run.

It may be on a different port. Try running 'netstat -lpt' as root and you
will get a listing of all TCP ports that are accepting connections and which
program is listening on each.

What is the relationship between CUPS and printcap file which I do not seem 
to have.  Don't I need that?

CUPS does not use /etc/printcap at all. (That file is part of lpr, lprng,
and other traditional printing systems, which CUPS is not.) However, some
applications expect /etc/printcap to be there and use information from it.

BTW: Response,  Not my idea, the installfest guys were trying to solve a 
network problem which remains.   Are you any good at debugging why two nic 
cards do not seem to work together on a machine?

Are they the same chipset or different chipsets? Are they common cards or
very new/exotic? In that case getting a driver directly from the
manufacturer or from the driver developers may be necessary. What does dmesg
say?
P.S. If you still want help from LERT please don't hesitate to mail
[EMAIL PROTECTED]
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Printing under KDE

[Henry House]

På fredag, 04 juni 2004, skrev Richard Ely:
> No, localhost:631 is not there.   I know it has been there and working 
> because we used cups to print a document the other night.  How do I install 
> it?  Probably trashed something trying to get the network to run.

It may be on a different port. Try running 'netstat -lpt' as root and you
will get a listing of all TCP ports that are accepting connections and which
program is listening on each.

> What is the relationship between CUPS and printcap file which I do not seem 
> to have.  Don't I need that?

CUPS does not use /etc/printcap at all. (That file is part of lpr, lprng,
and other traditional printing systems, which CUPS is not.) However, some
applications expect /etc/printcap to be there and use information from it.

> BTW: Response,  Not my idea, the installfest guys were trying to solve a 
> network problem which remains.   Are you any good at debugging why two nic 
> cards do not seem to work together on a machine?

Are they the same chipset or different chipsets? Are they common cards or
very new/exotic? In that case getting a driver directly from the
manufacturer or from the driver developers may be necessary. What does dmesg
say?

P.S. If you still want help from LERT please don't hesitate to mail
[EMAIL PROTECTED]

-- 
Henry House
The unintelligible text that may follow is a digital signature.
See  to find out how to verify it.
My OpenPGP key: .



signature.asc
Description: Digital signature

Re: [vox-tech] Burning ISO Images

[Robert G. Scofield]

Jeff Newmiller wrote:

First thing that comes to mind is the old "burning the image as a
file" problem... 


In a gui program, choose the "burn an image" option rather
than the "make a cd" option.
 

Okay, this was it.  The CD will now boot.
But I've got a super problem that no one can help me with now.  I've got 
a motherboard problem; Mandrake calls it a syncing problem.  My computer 
will run Windows98 but will not run Linux.  Before I got it "fixed" I 
couldn't even run Windows.  So now I need a new computer.

Thanks also to Jonathan and Mark.
Bob
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Burning ISO Images

[Jonathan Stickel]

FIW: I've seen several instances where the Mandrake install CDs don't 
want to boot.  I should test the ones I've burned at on my home 
computer, but I know they haven't worked at installfests when the Fedora 
CDs would.

Jonathan
Robert G. Scofield wrote:
I can't seem to burn a bootable Linux iso image.
I downloaded two of the three Mandrake 10.0 files.  I assume that CD 1 
is the bootable file.  But every time I burn a CD, the CD fails to 
boot.  Is there a secret as to how to get my downloaded file to boot?
Thank you.

Bob
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech
___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech

Re: [vox-tech] Burning ISO Images

[Jeff Newmiller]

On Thu, 3 Jun 2004, Robert G. Scofield wrote:

> I can't seem to burn a bootable Linux iso image.
> 
> I downloaded two of the three Mandrake 10.0 files.  I assume that CD 1 
> is the bootable file.  But every time I burn a CD, the CD fails to 
> boot.  Is there a secret as to how to get my downloaded file to boot? 

No secrets.  However, you may be missing something obvious... failing to
tell us what steps you took leaves us guessing.

First thing that comes to mind is the old "burning the image as a
file" problem... this is uncommon in Linux, but if you are using some kind
of fancy GUI burn program then you may be victim of this. I usually use:

 $ cdrecord -dao speed=16 dev=0,0,0 -data myisofile.iso

where the "0,0,0" comes from "cdrecord -scanbus", and the speed depends on
your drive. In a gui program, choose the "burn an image" option rather
than the "make a cd" option.

Another possibility is that you are downloading in a manner that corrupts
the file.  For example, if you download in Windows with Netscape from an
improperly configured http server, the server may deliver the binary file
but tell Netscape that it is a text file, and Netscape will perform CRLF
conversions and corrupt the file.  Use an md5sum or checksum program to
compare the actual checksum with the reported checksum to determine if you
have obtained an uncorrupted version of the file.

Is your cd drive set as a boot device ahead of your hard disk in the BIOS
setup?

---
Jeff NewmillerThe .   .  Go Live...
DCN:<[EMAIL PROTECTED]>Basics: ##.#.   ##.#.  Live Go...
  Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/BatteriesO.O#.   #.O#.  with
/Software/Embedded Controllers)   .OO#.   .OO#.  rocks...2k
---


___
vox-tech mailing list
[EMAIL PROTECTED]
http://lists.lugod.org/mailman/listinfo/vox-tech