12-17-2008
To remove the record from a file
Hi ,
In need to remove the record marked in red
My input is as below :
1|ETG|63121387883|Alternate|Y
2|||
3|79.58|||GBP||
4|001137001
4|0011372
5|1021701
5|1021901
1|ETG|63121387884|Alternate|Y
2|||
3|79.58|||GBP||
4|001137001
5|1021702
5|1021802
1|ETG|63128363077|Alternate|Y
2|||
2|EN_GB||Electrogalvanize 0.5 m2 ( Renault )
2|FR_GB||Electrogalvanize 0.5 m2 ( Renault )
3|88.51|||GBP||
4|001137001
4|001137002
5|1021901
5|7040500
1|ETG|63128363079|Alternate|Y
2|EN_GB||Electrogalvanize
2|||
4|001137005
5|2021901
5|8040500
My output is as below :
1|ETG|63121387883|Alternate|Y
2|||
3|79.58|||GBP||
4|001137001
4|0011372
5|1021701
5|1021901
1|ETG|63121387884|Alternate|Y
2|||
3|79.58|||GBP||
4|001137001
5|1021702
5|1021802
1|ETG|63128363077|Alternate|Y
2|EN_GB||Electrogalvanize 0.5 m2 ( Renault )
2|FR_GB||Electrogalvanize 0.5 m2 ( Renault )
3|88.51|||GBP||
4|001137001
4|001137002
5|1021901
5|7040500
1|ETG|63128363079|Alternate|Y
2|EN_GB||Electrogalvanize
4|001137005
5|2021901
5|8040500
Please let me if there are any commands for removing them.Any suggestions woild be hwlpful
Thanks in advance
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
If i have a file with xml format, i would like to remove duplicated records and save to a new file. Is it possible...to write script to do it? (8 Replies)
Discussion started by: happyv
8 Replies
2. UNIX for Dummies Questions & Answers
Hi,
First time on the forum. I have converted some files using the Unix to DOS command but need to strip off the last record that is generated from this conversion that contains just a ^Z. Is there any command that would accomplish this without having to do stream editing? (4 Replies)
Discussion started by: mheinen
4 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
Could some one help me how to delete first & last record from a file
Thanks in Advance.......
Regards
Cherrry (1 Reply)
Discussion started by: ravikuc
1 Replies
4. Shell Programming and Scripting
Please tell me the command(s) to remove a particular record from the file and placing the rest of the record in a seperate file. (9 Replies)
Discussion started by: kanu_pathak
9 Replies
5. Shell Programming and Scripting
Hi,
I have a fixed width file with record length 10.
I need to remove multiple newline characters present in each record.
EX:
af\n72/7\n
s\n3\nad\n
2\n\n33r\n
In the above file I want to remove new lines in red color(\n) but not (\n)
Please provide me a solution.
Thanks,
Sri (1 Reply)
Discussion started by: srilaxmi
1 Replies
6. Shell Programming and Scripting
Hi:),
I am having 110 records in a file and I want to delete particular record (say 63rd) . Which command can be use to achieve this ? (4 Replies)
Discussion started by: devmns
4 Replies
7. Shell Programming and Scripting
Dear Friends,
Need your help to fix the issue we are facing.
We have a requirement - Need to remove specific records from a comma separated file and create new file. It should check "filter.csv" file and then accordingly remove records from the input file and generate the output file.(not case... (5 Replies)
Discussion started by: SatishW
5 Replies
8. Shell Programming and Scripting
Hi ,
I want to remove space from each record in one file My file is like
BUD, BDL
ABC, DDD, ABC
ABC, DDD, DDD, KKK
The o/p should be
BUD,BDL
ABC,DDD,ABC
ABC,DDD,DDD,KKK
Can any one help me regarding this? (9 Replies)
Discussion started by: jagdishrout
9 Replies
9. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
10. Shell Programming and Scripting
export PATH=$PATH:/opt/IBM/db2/V9.5/95fp4/bin
DB2INSTANCE=bancbcb1
export DB2INSTANCE
db2 "connect to dyaxprpt user xyz using byx"
echo "Load lastest data start"
Row=$(db2 –x “delete from xyz.ROL_yxpwhere axl_ING_ID in(50127,50455,503458,175748)”)
If ; then
echo “no data deleted”
elif ;... (2 Replies)
Discussion started by: jagu
2 Replies
LEARN ABOUT DEBIAN
tinydyndns-data
tinydyndns-data(8) System Manager's Manual tinydyndns-data(8)
NAME
tinydyndns-data - add or remove TYPE A record to or from data.cdb
SYNOPSIS
tinydyndns-data add|remove fqdns
DESCRIPTION
fqdns consists of one or more argument, each specifying a fully qualified domain name (fqdn).
tinydyndns-data adds a TYPE A record to or removes it from data.cdb in the current directory. Other than tinydns-data(8), tinydyndns-data
does not know about the source file data but changes the binary database data.cdb directly.
tinydyndns-data reads data.cdb and copies its data to data.tmp. While reading the records, tinydyndns-data checks for each fqdn in fqdns
if this hostname has a TYPE A record in data.cdb, drops the record when called with the option remove, or refuses to add the record when
called with the option add.
When called with the option add, tinydyndns-data then adds all new fqdns to data.tmp. The data of the newly created records can optionally
be controlled through the environment, see below. Finally tinydyndns-data renames data.tmp to data.cdb.
OPTIONS
add For each fqdn in fqdns, add a TYPE A record for fqdn to data.cdb with the default IP address (127.14.14.14).
remove For each fqdn in fqdns, remove all TYPE A records for fqdn from data.cdb.
ENVIRONMENT
IP The environment variable IP overrides the default IP address (``127.14.14.14'') for newly created records. $IP must be a valid IP
address.
TTL time-to-live. The environment variable TTL overrides the default time-to-live in seconds (0 if TTD is set, otherwise 5). $TTL must
be an integer.
TTD time-to-die. $TTD must be an integer, specifying a number of seconds. If TTD is set, the timestamp of newly created records is set
to the current time plus $TTD seconds, and TTL is set to zero by default, so that tinydns(8) interpretes the timestamp as time-to-
die. Note: you probably want to adjust SOA ttl, or create a wildcard record, to prevent DNS caches from caching nxdomain, when
using this feature.
LOC location. $LOC must be two characters long. If LOC is set, it specifies the client location for newly created records.
EXIT CODES
tinydyndns-data exits 111 if anything goes wrong and leaves data.cdb unchanged.
tinydyndns-data exits 0 if all fqdns were processed and the new data.cdb was written.
For each fqdn in fqdns that tinydyndns-data was not able to remove or add (e.g., not there, or already there), it increases the exit code
by one and exits non-zero (maximum is 100).
FILES
./data.cdb
./data.tmp
SEE ALSO
tinydyndns-update(8), tinydyndns-conf(8)
http://smarden.org/tinydyndns/
AUTHOR
Gerrit Pape <pape@smarden.org>
tinydyndns-data(8)