hii i have a huge amt of data stored in a file.Here in this file i need to remove duplicates rows in such a way that the last column has different data & i must check for greatest among last colmn data & print the largest data along with other entries but just one of other duplicate entries is... (16 Replies)
I need to delete rows based on the number of lines in a different file, I have a piece of code with me working but when I merge with my C application, it doesnt work.
sed '1,'\"`wc -l < /tmp/fileyyyy`\"'d' /tmp/fileA > /tmp/filexxxx
Can anyone give me an alternate solution for the above (2 Replies)
Hello list,
I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address).
... (4 Replies)
HI all,
I have a simple challenge for you.. I have the following pipe delimited file
2345|98|1809||x|969|0
2345|98|0809||y|0|537
2345|97|9809||x|544|0
2345|97|0909||y|0|651
9685|98|7809||x|321|0
9685|98|7909||y|0|357
9685|98|7809||x|687|0
9685|98|0809||y|0|234
2315|98|0809||x|564|0
... (2 Replies)
Hi all
I have a file which looks like this
1234|1|Jon|some text|some text
1234|2|Jon|some text|some text
3453|5|Jon|some text|some text
6533|2|Kate|some text|some text
4567|3|Chris|some text|some text
4567|4|Maggie|some text|some text
8764|6|Maggie|some text|some text
My third column is my... (9 Replies)
Hi,
This may not be the right forum but i am hoping someone knows an answer to this.
I have to capture rows for a column that was deleted. How can i do that without having to write a select query?
delete from myschema.mytable where currentdatetimestamp > columnDate
this should delete 5... (4 Replies)
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there
e.g.
file 01
James|0|50|25|10|50|30... (1 Reply)
i have a table like this:
id, senderNumber, blacklist
-----------------------------
1 0835636326 Y
2 0373562343 Y
3 0273646833 Y
and I want to delete automatically if a new inserted row on another table consist anything on senderNumber column above using a BASH Script
I... (9 Replies)
ISCNTRL(3) BSD Library Functions Manual ISCNTRL(3)NAME
iscntrl -- control character test
LIBRARY
Standard C Library (libc, -lc)
SYNOPSIS
#include <ctype.h>
int
iscntrl(int c);
int
iscntrl_l(int c, locale_t loc);
DESCRIPTION
The iscntrl() function tests for any control character. The value of the argument must be representable as an unsigned char or the value of
EOF.
In the ASCII character set, this includes the following characters (with their numeric values shown in octal):
000 NUL 001 SOH 002 STX 003 ETX 004 EOT
005 ENQ 006 ACK 007 BEL 010 BS 011 HT
012 NL 013 VT 014 NP 015 CR 016 SO
017 SI 020 DLE 021 DC1 022 DC2 023 DC3
024 DC4 025 NAK 026 SYN 027 ETB 030 CAN
031 EM 032 SUB 033 ESC 034 FS 035 GS
036 RS 037 US 177 DEL
The iscntrl_l() function takes an explicit locale argument, whereas the iscntrl() function uses the current global or per-thread locale.
RETURN VALUES
The iscntrl() function returns zero if the character tests false and returns non-zero if the character tests true.
COMPATIBILITY
The 4.4BSD extension of accepting arguments outside of the range of the unsigned char type in locales with large character sets is considered
obsolete and may not be supported in future releases. The iswcntrl() function should be used instead.
SEE ALSO ctype(3), iswcntrl(3), xlocale(3), ascii(7)STANDARDS
The iscntrl() function conforms to ISO/IEC 9899:1990 (``ISO C90''). The iscntrl_l() function conforms to IEEE Std 1003.1-2008 (``POSIX.1'').
BSD July 17, 2005 BSD