|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Count the delimeter from a file and delete the row if delimeter count doesnt match.
Post 302449819 by Akumar1 on Tuesday 31st of August 2010 04:24:06 PM
08-31-2010
Count the delimeter from a file and delete the row if delimeter count doesnt match.
Many thanks for the reply,
however by using below command I am able to take out unwated rows in another file , but I want those rows shoud get deleted from main file. any help
perl -ne
however by using below command I am able to take out unwated rows in another file , but I want those rows shoud get deleted from main file. any help
perl -ne
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
#!/bin/bash
i=0
cat 1.csv | while read fileline
do
echo "$fileline"
IFS="#" flds=( $fileline )
nrofflds=${#flds}
echo "noof fields$nrofflds"
fld=0
while
do
echo "noof counter$fld"
echo "$nrofflds"
#fld1="${flds}" trying to store the content of line to fields but i... (4 Replies)
Discussion started by: barani75
4 Replies
2. Shell Programming and Scripting
Hi
I need to write a small script to kill the process id of particular job in one shot ,
Example
> ps
PID TTY TIME COMMAND
16280 pts/70 0:00 sh
16278 pts/70 0:00 rlogind
16197 pts/70 0:00 ps
1234 pts/70 0:00 runflow
2341 pts/70 0:00 runflow
12673 pts/70 ... (6 Replies)
Discussion started by: mani_isha
6 Replies
3. Shell Programming and Scripting
I have a sorted file like:
Apple 3
Apple 5
Apple 8
Banana 2
Banana 3
Grape 31
Orange 7
Orange 13
I'd like to search $1 and if $1 is not the same as $1 in the previous row print that row and print the number of times $1 was found.
so the output would look like:
Apple 8 3
Banana... (2 Replies)
Discussion started by: dcfargo
2 Replies
4. Shell Programming and Scripting
Hi guys, plz tell me how to achieve this
how to delete the lines in a file using sed command (6 Replies)
Discussion started by: hari908
6 Replies
5. Shell Programming and Scripting
Hi All,
My file has the records as below:
aaa\bbb\c\dd\ee\ff\gg
zz\vv\ww
pp\oo\ii\uu
How can I get the value after the last delimeter.
My o/p:
gg
ww
uu
Thanks in Advance, (5 Replies)
Discussion started by: HemaV
5 Replies
6. Shell Programming and Scripting
Hi Friends,
I have a file1.txt as below
29123973Ç2012-0529Ç35310124Ç000000000004762Ç00010Ç20Ç390ÇÇÇÇF
29123974Ç20120529Ç35310125Ç0000000000046770Ç00010Ç20Ç390ÇÇÇÇF
29123975Ç20120529Ç35310126Ç0000000000046804Ç00010Ç20Ç390ÇÇÇÇF
29123976Ç20120529Ç35310127Ç0000000000044820Ç00010Ç20Ç390ÇÇÇÇF
i have a file2.txt... (4 Replies)
Discussion started by: i150371485
4 Replies
7. Shell Programming and Scripting
I have a below file.
INPUT FILE
select * from customer
MERGE INTO Archive; delete from Employee; using select * from customer;
delete from employee; select * from Employee;
insert into employee(1,1);
OUTPUT FILE
select * from customer
MERGE INTO Archive
delete from Employee
using... (5 Replies)
Discussion started by: Mohin Jain
5 Replies
8. UNIX for Beginners Questions & Answers
Good evening, need your help please
Need to delete certain files before octobre 1 2016, so need to know how many files im going to delete, for instance
ls -lrt file_20160*.lis!wc -l
but using grep -c to another file called bplist which contains the list of all files backed up doesn match... (7 Replies)
Discussion started by: alexcol
7 Replies
9. Shell Programming and Scripting
I have a file
H,20180624200732,VPAS,TRANS_HDR,20180724,
VPAS.TRANS_HDR.20180724.01.txt, ,93,
T,1,
I have to change and instead first comma put ",1" like below
H,20180624200732,VPAS,TRANS_HDR,20180724,
VPAS.TRANS_HDR.20180724.01.txt,1,93,
T,1,
I made
sed "2s/, /,1/"... (8 Replies)
Discussion started by: digioleg54
8 Replies
10. Shell Programming and Scripting
The OS version is
Red Hat Enterprise Linux Server release 6.10
I have a script to mask some columns with **** in a data file which is delimeted with Ç ,
I am using awk for the masking , when I try to mask a small file the awk works fine and masks the required column ,
but when the file is... (6 Replies)
Discussion started by: LinuxUser8092
6 Replies
LEARN ABOUT PHP
pg_num_rows
PG_NUM_ROWS(3) PG_NUM_ROWS(3) pg_num_rows - Returns the number of rows in a result SYNOPSIS
int pg_num_rows (resource $result) DESCRIPTION
pg_num_rows(3) will return the number of rows in a PostgreSQL result resource. Note This function used to be called pg_numrows(3). PARAMETERS
o $result - PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others). RETURN VALUES
The number of rows in the result. On error, -1 is returned. EXAMPLES
Example #1 pg_num_rows(3) example <?php $result = pg_query($conn, "SELECT 1"); $rows = pg_num_rows($result); echo $rows . " row(s) returned. "; ?> The above example will output: 1 row(s) returned. SEE ALSO
pg_num_fields(3), pg_affected_rows(3). PHP Documentation Group PG_NUM_ROWS(3)