09-25-2012
Delete records from a big file based on some condition
Hi,
To load a big file in a table,I have a make sure that all rows in the file has same number of the columns .
So in my file if I am getting any rows which have columns not equal to 6 , I need to delete it . Delimiter is space and columns are optionally enclosed by "".
This can be identified like this :
COLUMN_1 COLUMN2 COLUMN_3 COLUMN4 COLUMN_5 COLUMN6
Correct Records :
123 1 3 test "abc def test" 200
234 1 3 "test" "abc def test" 200
456 1 3 "test" "abc def test" "abc 200"
Records to be deleted from the file
678 1 3 test "abc def test"
789 1 3 "test" "abc def test" 200 1234
Row 678 .. has number of columns as 5 instead of 6 and row 789 has number of columns at 7 instead of 6. So need to delete these records from the file.
Can count the number of columns using this , but not sure to proceed further.
perl -nle 's/".*?"//g;print s/,//g+1'
Any pointed further will be appreciated.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a 5 gig file, no record terminators, field terminators are newline. The record length is 768 and I would like to check that every 768th byte is a newline and print out the byte position if it isn't. I would like to do this going either forward or backwards with one command if... (3 Replies)
Discussion started by: vtischuk@yahoo.
3 Replies
2. Shell Programming and Scripting
For example suppose I have a file which contains data as:
$cat data
800,2
100,9
700,3
100,9
200,8
100,3
Now I want the output as
200,8
700,3
800,2
Key is first three characters, I don't want any reords which are having duplicate keys.
Like sort +0.0 -0.3 data can we use... (9 Replies)
Discussion started by: sumitc
9 Replies
3. Shell Programming and Scripting
Hello!
Is there a way i can read a file with n records as one big string using linux shell script? I have a file in the below format -
REC1
REC2
REC3
.
.
.
REC4
Record length is 3000 bytes per record and with a newline char at the end. What i need to do is
- read this file as one... (5 Replies)
Discussion started by: mailme0205
5 Replies
4. Shell Programming and Scripting
Hi all,
I have a big file (about 6 millions rows) and I have to delete same occurrences, stored in a small file (about 9000 rews). I have tried this:
while read line
do
grep -v $line big_file > ok_file.tmp
mv ok_file.tmp big_file
done < small_file
It works, but is very slow.
How... (2 Replies)
Discussion started by: Tibbeche
2 Replies
5. Shell Programming and Scripting
Hi Unix team,
I have a file with 30 columns with tab delimited. I need to count the records based on column 18 & 21 data.
So I cut the data from the file using
awk -F"\t" '{print $18,$21}' foo.txt
Following is the output:
USED SEDAN
USED SUV
NEW SUV
USED Truck
USED Truck
USED... (6 Replies)
Discussion started by: karumudi7
6 Replies
6. Shell Programming and Scripting
Hi Friends,
I have the following file,
cat input
chr1 1000 2000
chr1 600 699
chr1 701 1000
chr1 600 1710
chr2 900 1800
Now, I would like to see the difference of
Record1.Col2 - Record2.Col2
Record1.Col2 - Record2.Col3
Record1.Col3 - Record2.Col2
Record1.Col3 - Record2.Col3
... (1 Reply)
Discussion started by: jacobs.smith
1 Replies
7. Shell Programming and Scripting
Hi,
Can any one help me, in deleting the records from the database table based on the following condition:
script should take a configurable parameter as input. The input is nothing but “no. of years”.
For example, if I enter 2 as input parameter, then the 2 year old records should get... (2 Replies)
Discussion started by: zxcjggu708
2 Replies
8. Shell Programming and Scripting
I want to keep last 2 days data from a file and want to delete others data from the file. Please help me.
Sample Input
# cat messages-2
Apr 15 11:25:03 test1 kernel: imklog 4.6.2, log source = /proc/kmsg started.
Apr 15 11:25:03 test1 rsyslogd: (re)start
Apr 16 19:42:03 test1 kernel:... (2 Replies)
Discussion started by: makauser
2 Replies
9. UNIX for Dummies Questions & Answers
Hi Folks,
I am a novice and need to build a script in bash. I have 2 text files data.txt file is big file, column 2 is the we need to search and delete in the output. The filter file contains the rows to be deleted.
Data.txt
state city zone
Alabama Huntsville 4
California SanDiego 3... (3 Replies)
Discussion started by: tech_frk
3 Replies
10. Shell Programming and Scripting
Hi
I have two files one.txt and two.txt
one.txt
123
324
456
235
456
two txt
abc one 000 123 abc
abc one 000 456 abc
abc one 000 122 abc
abc one 000 111 abc
My question here is, the records which are present in one.txt has to deleted in second file two.txt
my output result... (2 Replies)
Discussion started by: Ganesh L
2 Replies
LEARN ABOUT DEBIAN
ecaccess-event-grant
ECACCESS-EVENT-GRANT(1p) User Contributed Perl Documentation ECACCESS-EVENT-GRANT(1p)
NAME
ecaccess-event-grant - Grant usage of an ECaccess Event
SYNOPSIS
ecaccess-event-grant -version|-help|-manual
ecaccess-event-grant [-debug] [-subscribe] [-notify] event-id user-list
DESCRIPTION
Allow managing the Event permissions for a list of user(s).
The permissions can be either subscribe, notify, both or none. In order to remove permissions to an Event for a list of users use this
command with no -subscribe and -notify options.
ARGUMENTS
event-id
The identifier of the Event to grant.
user-list
The user(s) to give/remove the permissions. Multiple users should be separated by a column (e.g. abc,def).
OPTIONS
-subscribe
The user(s) specified in the user-list will be allowed to subscribe to the event-id (e.g. with the -eventIds option of the
ecaccess-job-submit command).
-notify The user(s) specified in the user-list will be allowed to send notifications to the event-id (e.g. with the ecaccess-event-send
command).
-version
Display version number and exits.
-help Print a brief help message and exits.
-manual Prints the manual page and exits.
-debug Display the SOAP messages exchanged.
EXAMPLES
ecaccess-event-grant -subscribe 167 abc,def,jhi
Allow the users abc, def and jhi to subscribe to this Event.
ecaccess-event-grant 167 jkl
Remove all rights to the Event for the user jkl.
SEE ALSO
ecaccess-event-clear, ecaccess-event-delete, ecaccess-event-send, ecaccess-event-list, ecaccess-event-create and ecaccess.
perl v5.14.2 2012-04-16 ECACCESS-EVENT-GRANT(1p)