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
anubisadm
ANUBISADM(1) General Commands Manual ANUBISADM(1)
NAME
anubisadm - interface for GNU Anubis database administration
SYNOPSIS
anubisadm anubisadm [COMMAND] [OPTIONS] URL
DESCRIPTION
This manual page documents briefly the anubisadm command.
anubisadm is a program for GNU Anubis database manipulation.
OPTIONS
A summary of options is included below:
COMMAND is one of:
-c, --create
Creates the database.
-l, --list
List the contents of an existing database.
-a, --add
Add a new record.
-m, --modify
Modify existing record.
-r, --remove
Remove existing record.
--version
Display program version number and exit.
--help Display this help screen and exit.
OPTION is one or more of:
-i, --authid=STRING
Specify the authid to operate upon. This option is mandatory with --add, --modify and --remove. It is optional when used with
--list.
-p, --password=STRING
Specify the password for the authid. Mandatory with --add, --modify and --remove.
-u, --user=STRING
Specify the system user name corresponding to the given authid. Optional for --add, --modify and --remove.
-f, --rcfile=STRING
Specify the rc file to be used for this authid. Optional for --add, --modify and --remove.
SEE ALSO
anubis(1), anubisusr(1),
AUTHOR
anubisadm was written by The Anubis Team (read the AUTHORS file).
This manual page was prepared by Krzysztof Burghardt <krzysztof@burghardt.pl>, for the Debian project (but may be used by others).
2007 Sep 09 ANUBISADM(1)