delete rows with a criteria Post: 302630971

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Selecting rows with a specific criteria

Hi, I want a UNIX command that can filter out rows with certain criteria. The file is tab deliminated. Row one is just a value. Basically what I want to do is select based on the name and character at the end (o). So lets lets say i want a row that has WashU and (o) then it would print...

2. Shell Programming and Scripting

Delete new lines based on search criteria

Hi all! A bit of background: I am trying to create a script that formats SQL statements. I have gotten so far as to add new lines based on certain match criteria like commas, keywords etc. In the process, I end up adding newlines where I don't want. For example: substr(colName, 1, 10)...

3. Shell Programming and Scripting

delete rows in a file based on the rows of another file

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

4. Shell Programming and Scripting

awk search & delete located criteria

Guys, I manages to get awk to search and print the files that I want to delete. However I am stuck on the delete portion. Here is the command that I am using to fins these files. find /usr/local/apache/conf/vhosts/ -type f | awk '/e$/' The output is perfect. The files look like so: ...

5. Shell Programming and Scripting

pull out rows with specific criteria

Hi, I have a file with multiple columns and for column 5 I want to extract that row into another file if it is equal to or greater than a certain value. For example: FAR 4 5 7 LOP GAT 3 3 3 POL I want values that are greater than 5 for column 4. So the final file will look like...

6. Shell Programming and Scripting

delete the same rows

each individual (row) has genotype expressed for each SNP (column) file1.txt 1 1 A G A T G T A A A A A A A A A A A A A A A A A A A A A 2 2 G A A A A A A A A A A A A A A A A A A A A A A A A A A 3 3 A A A A A A A A A A A A A A A A A A A A A A A A A A A 4 4 G A G T A T A A A A A A A A A A A...

7. Shell Programming and Scripting

Need To Delete Lines Based On Search Criteria

Hi All, I have following input file. I wish to retain those lines which match multiple search criteria. The search criteria is stored in a variable seperated from each other by comma(,). SEARCH_CRITERIA = "REJECT, DUPLICATE" Input File: ERROR,MYFILE_20130214_11387,9,37.75...

8. UNIX for Dummies Questions & Answers

How to delete rows?

I have an Output file which has the result YYYY 95,77 YYYY YYYY 95 YYYY 95 YYYY 95 YYYY 95 YYYY 95 YYYY 95 YYYY 95 YYYY 95 YYYY YYYY YYYY YYYY I would like to display the above along with a single line with above info. Final output should be YYYY 95

9. Shell Programming and Scripting

Rows to Columns with match criteria

Hello Friends, I have a input file having hundreds of rows. I want them to translate in to columns if column 1 is same. Input data: zp06 xxx zp06 rrr zp06 hhh zp06 aaa zp06 ggg zp06 qwer zp06 ser zl11 old3 zl11 old4 zl11 old5 zl11 old6 zl11 old7 zm14 luri zm14 body zm14 ucp

10. Shell Programming and Scripting

Delete duplicate row based on criteria

Hi, I have an input file as shown below: 20140102;13:30;FR-AUD-LIBOR-1W;2.495 20140103;13:30;FR-AUD-LIBOR-1W;2.475 20140106;13:30;FR-AUD-LIBOR-1W;2.495 20140107;13:30;FR-AUD-LIBOR-1W;2.475 20140108;13:30;FR-AUD-LIBOR-1W;2.475 20140109;13:30;FR-AUD-LIBOR-1W;2.475...

LEARN ABOUT DEBIAN

portabase

PORTABASE(1)						      General Commands Manual						      PORTABASE(1)

NAME

       portabase - an easy-to-use personal database application

SYNOPSIS

       portabase [ -h | --help | <file> ]
       portabase command [ -p password ] [ options ] <fromfile> <tofile>

DESCRIPTION

       PortaBase  (portable database) is a personal database application that is available for many platforms, including Linux, Mac OS X, Windows,
       and Maemo.

       PortaBase's features include:

       - One data table per file

       - String, Integer, Decimal, Boolean, Note (multi-line text), Date,
	 Time, Calculation, Sequence, Image, and Enum column types

       - Add, edit, and delete rows of data

       - Custom data views (subsets of the columns in any order)

       - Filter the displayed rows using sets of conditions

       - Sort the rows by any combination of columns, each in ascending or
	 descending order

       - Optional page navigation buttons, with a custom number of rows per page

       - Add, delete, rearrange, and rename columns at any time

       - Specify default values for columns

       - View summary statistics for columns (total, average, min, max, etc.)

       - Import data from CSV, XML, and MobileDB files

       - Export data to CSV and XML files

       - Command-line format conversions (to and from XML, from MobileDB)

       - Data file encryption

       - Unicode support

       - Pick any available font to use throughout the application

COMMANDS

       PortaBase uses the following commands to indicate a command-line file conversion:

       fromxml
	      Create a new PortaBase file from the input XML file.

       frommobiledb
	      Create a new PortaBase file from the input MobileDB file.

       fromcsv
	      Add rows to an existing PortaBase file from the input CSV file.

       toxml  Create a new XML file from the input PortaBase file.

       tocsv  Create a new CSV file from the input PortaBase file.

       If an encrypted PortaBase file is to be read or created, the following option can be used immediately after the command:

       -p <password>
	      Open or create the encrypted PortaBase file using the given password

       The toxml and tocsv commands accept the following options:

       -v <view>
	      Apply the named view before exporting.

       -s <sorting>
	      Apply the named sorting before exporting.

       -f <filter>
	      Apply the named filter before exporting.

       The fromcsv command supports one option:

       -e <encoding>
	      Specifies the text encoding of the imported CSV file; options are UTF-8 (the default) and Latin-1.

OPTIONS

       PortaBase accepts the following options:

       -h, --help
	      Display usage instructions.

FILES

       $HOME/.qt/portabaserc - user-specific settings.	Stores information on font, checkbox editing, delete confirmations, etc.

AUTHOR

       This manual page was written by Jeremy Bowman <jmbowman@alum.mit.edu>, for the Debian GNU/Linux system (but may be used by others).

								  April 16, 2010						      PORTABASE(1)