Hi guys,
I could do with some help with a script to manipulate a data-file so I can
substitute values "_at_" for "" (null).
The following is example output from dumping a database, where the dump
command does the opposite, ie where tha value is null in the database the
output has an _at_.
<snip>
2|10158086|34|21502169000342X|AU6|1|19950313|13/03/95,00001|C|1|94000000|_at_|
Y||_at_|_at_|19691231|0|_at_|
2|10158086|35|486191270001536|AU6|1|19950313|13/03/95,00001|C|1|94000001|_at_|
Y||_at_|_at_|19691231|0|_at_|
2|10158086|36|192070110001719|AU6|1|19950313|13/03/95,00001|C|1|94000002|_at_|
Y||_at_|_at_|19691231|0|_at_|
2|10158086|37|372011910003150|AU6|1|19950313|13/03/95,00001|C|1|94000003|_at_|
Y||_at_|_at_|19691231|0|_at_|
<snip>
1|10158086|80781|520449921000000|_at_|_at_|19950320|20/03/95,00237,SCAN &
DES|C|1|94080698|_at_|Y||_at_|_at_|19691231|0|_at_|
1|10158086|80782|206017190001215|Z|_at_|19950420|YORK,20/04/95,0003|C|1|940806
99|_at_|Y||_at_|_at_|19691231|0|_at_|
<snip>
I guess this should be simple using sed/awk/perl etc. but I have not done
much text manipulation under UNIX. One problem is that it may not be the
same field that has an _at_ in each record
Sorry for seeming dumb!
Regards
Mark Cuthbert
Yorkshire Water
UK
The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at
http://www.keldagroup.com/email.htm
Kelda Group plc and its subsidiaries, UK
Registered in England and Wales No 2366627
Received on Wed Oct 20 1999 - 10:58:17 NZDT