---------- Post updated at 09:24 PM ---------- Previous update was at 09:14 PM ----------
Please note that the example you paste is not <tab> delimited, it contains a lot of space and only one tab just before the "Green".
You can reformate your input to change successions of spaces into one tab :
Note that there are 2 <space> before the wildcard.
Also press <Ctrl>+<V> keys before pressing the <tab> key so to be more clear here are the keys you will have tyo press:
and then run your extraction on the properly formatted file :
Greetings,
I would like to extract records from a fixed width text file that have unique field elements.
Data is structured like this:
John A Smith NY
Mary C Jones WA
Adam J Clark PA
Mary Jones WA
Fieldname / start-end position
Firstname 1-10... (8 Replies)
I have a file with 14million lines and I would like to extract all the unique lines from the file into another text file.
For example:
Contents of file1
happy
sad
smile
happy
funny
sad
I want to run a command against file one that only returns the unique lines (ie 1 line for happy... (3 Replies)
Hi all! Im trying to extract a portion of text from a file and put it into a new file. I need all the lines between <Placement> and </Placement> including the Placemark lines themselves. Is there a way to extract all instances of these and not just the first one found? I've tried using sed and... (4 Replies)
I'm attempting to write a script to identify users who have sudo access on a server. I only want to extract the ID's of the sudo users after a unique line of text. The list of sudo users goes to the EOF so I only need the script to start after the unique line of text. I already have a script to... (1 Reply)
Is it possible to print the records that has only 1 value in 2nd column.
Ex:
input
awex1 1
awex1 2
awex1 3
assww 1
ader34 1
ader34 2
output
assww 1 (5 Replies)
Hi Folks,
I have the below feed file named abc1.txt in which you can see there is a title and below is the respective values in the rows and it is completely pipe delimited file ,.
... (4 Replies)
I have a series of csv files in the following format
eg file1
Experiment Name,XYZ_07/28/15,
Specimen Name,Specimen_001,
Tube Name, Control,
Record Date,7/28/2015 14:50,
$OP,XYZYZ,
GUID,abc,
Population,#Events,%Parent
All Events,10500,
P1,10071,95.9
Early Apoptosis,1113,11.1
Late... (6 Replies)
Discussion started by: pawannoel
6 Replies
LEARN ABOUT DEBIAN
dbix::dbschema::index
DBSchema::Index(3pm) User Contributed Perl Documentation DBSchema::Index(3pm)NAME
DBIx::DBSchema::Index - Index objects
SYNOPSYS
use DBIx::DBSchema::Index;
$index = new DBIx::DBSchema::Index (
{
}
);
DESCRIPTION
DBIx::DBSchema::Index objects represent a unique or non-unique database index.
METHODS
new HASHREF | OPTION, VALUE, ...
Creates a new DBIx::DBschema::Index object.
Accepts either a hashref or a list of options and values.
Options are:
name - Index name
using - Optional index method
unique - Boolean indicating whether or not this is a unique index.
columns - List reference of column names (or expressions)
name [ INDEX_NAME ]
Returns or sets the index name.
using [ INDEX_METHOD ]
Returns or sets the optional index method.
unique [ BOOL ]
Returns or sets the unique flag.
columns [ LISTREF ]
Returns or sets the indexed columns (or expressions).
columns_sql
Returns a comma-joined list of columns, suitable for an SQL statement.
sql_create_index TABLENAME
Returns an SQL statment to create this index on the specified table.
cmp OTHER_INDEX_OBJECT
Compares this object to another supplied object. Returns true if they are identical, or false otherwise.
cmp_noname OTHER_INDEX_OBJECT
Compares this object to another supplied object. Returns true if they are identical, disregarding index name, or false otherwise.
AUTHOR
Ivan Kohler <ivan-dbix-dbschema@420.am>
Copyright (c) 2007 Ivan Kohler Copyright (c) 2007 Freeside Internet Services, Inc. All rights reserved. This program is free software;
you can redistribute it and/or modify it under the same terms as Perl itself.
BUGS
Is there any situation in which sql_create_index needs to return a list of multiple statements?
SEE ALSO
DBIx::DBSchema::Table, DBIx::DBSchema, DBI
perl v5.14.2 2007-06-28 DBSchema::Index(3pm)