separate the file according to the number of fields
I have a file which is delimetered by ',' i need to filter out a file with respect to the number of fileds in each line.
in this
i neeed to filter out the lines with 8 column to another file and rest to another file.
so
will go to first.txt
all the rest should go to second.txt
any help?
Last edited by zaxxon; 08-17-2011 at 07:17 AM..
Reason: code tags
hi,
I am a begginer in unix and i want to know how to open a file and read it and separate the numbers & words and storing it in separate files, Using shell scripting.
Please help me out for this.
Regards
S.Kamakshi (2 Replies)
I'm working on formatting some attendance data to meet a vendors requirements to upload to their system. With some help on the forums here, I have the data close. But they've since changed what they want.
The vendor wants me to submit three fields to them. Field 1 is the studentid field,... (4 Replies)
Hi everyone!
I have a field like that:
I need to keep
I don't know how to use the Capital character like a separator and how to keep only this one...
I guess sed could do something like that...
Thanks;) (3 Replies)
SHELL SCRIPT
Hi,
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
mayank
sushant
dheeraj
File2 contains
DSA_AT
MG_AT
FLAT_09
File3 contains data
123123
232323 (2 Replies)
I have a text file with 1,000,000 rows (It is a single column text file of numbers). I would like to separate the text file into 100 files of equal size (i.e. number of rows). The first file will contain the first 10,000 rows, the second row will contain the second 10,000 rows (rows 10,001-20,000)... (2 Replies)
Hello,
:wall:
I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books.
I know this does not work
/^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d
Any ideas?
Thanks
Please... (2 Replies)
awk 'NF==2{s=$1;next}{$(NF+1)=s}1' sort.txt > output.txt
A_16_P32713632 chr10 90695750 90695810 ACTA2
A_16_P32713635 chr10 90696573 90696633 ACTA2
A_16_P32713680 chr10 90697419 90697479 ACTA2
The command above outputs the data as a string separated by a space in 1 field. I can not... (6 Replies)
I am trying to use awk to find all the $3 values in file2 that are between $2 and $3 in file1. If a value in $3 of file2 is between the file1 fields then it is printed along with the $6 value in file1. Both file1 and file2 are tab-delimited as well as the desired output. If there is nothing to... (4 Replies)
Hi,
Below are the sample files. x.txt is from an Excel file that is a list of users from Windows and y.txt is a list of database account.
$ head -500 x.txt y.txt
==> x.txt <==
TEST01 APP_USER_PROFILE
USER03 APP_USER_PROFILE
TEST02 APP_USER_EXP_PROFILE
TEST04 APP_USER_PROFILE
USER01 ... (3 Replies)
So, I have three problems that cover this subject.
First one asks me to find the number of fields in the file that contain the substring "he". I found the number of fields, but the problem I have is that they are displaying by each record. I want to add all of the records' fields together.
With... (2 Replies)
Discussion started by: mc10
2 Replies
LEARN ABOUT DEBIAN
mimedefang.pl
MIMEDEFANG.PL(8) System Manager's Manual MIMEDEFANG.PL(8)NAME
mimedefang.pl - Perl script to scan MIME messages.
SYNOPSIS
mimedefang.pl [-f filter] dir
DESCRIPTION
mimedefang.pl is a Perl script designed to work with mimedefang(8). It takes a single argument which is a directory which should contain
files laid out as described in mimedefang(8).
OPTIONS -f filter
Specifies the name of the file containing the filter. If this option is omitted, the default filter /etc/mimedefang-filter is used.
OPERATION
mimedefang.pl evaluates the file /etc/mimedefang-filter as a Perl fragment. This file should define the filter procedure. For each part
of a MIME message, mimedefang.pl calls filter and disposes of the part as instructed by the filter. The various modes of disposition are
described in mimedefang-filter(5).
TESTING FILTERS
You are strongly recommended to test your filter before installing it in /etc/mimedefang-filter. To test the filter, save it in a file
(e.g. test-filter) and run this command:
mimedefang.pl -f test-filter -test
This tests the filter for syntactic correctness. If it passes, you can install it as a production filter. (Note that the test tests only
for correct Perl syntax; it doesn't make sure your filter does something sensible.)
MISCELLANEOUS OPTIONS
There are a few other ways to invoke mimedefang.pl:
mimedefang.pl -structure < mime_message
parses a message on stdin and prints lots of debugging information.
mimedefang.pl -prettyprint < mime_message
parses a message on stdin and prints it in a "nice" format (depending on your definition of "nice".)
mimedefang.pl -features
prints a list of detected optional Perl modules. The output looks something like this:
SpamAssassin: yes
mimedefang.pl -validate
calls the function filter_validate, if it is defined in your filter. filter_validate should return an integer; this becomes the exit code.
If filter_validate does not exist, an error message is printed and mimedefang.pl exits with an exit code of 1.
AUTHOR
mimedefang.pl was written by David F. Skoll <dfs@roaringpenguin.com>. The mimedefang home page is http://www.mimedefang.org/.
SEE ALSO mimedefang(8), mimedefang-filter(5), mimedefang-protocol(7)4th Berkeley Distribution 8 February 2005 MIMEDEFANG.PL(8)