09-09-2011
suppose I dont have any / in my 3 field
or
I want first 4 fields from file
thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i have a file of the below format:
WA| 3|52|Waste |
PW| 3|53|Promotion Waste |
BR| 3|54|Breakage |
TH| 3|55|Theft |
IC| 3|56|Insurance Claim |
I want to replace the last delimiter | by using sed command ...can u please help me witht this
Thanks in... (4 Replies)
Discussion started by: jisha
4 Replies
2. Shell Programming and Scripting
hey guys can you please help me out,
i'm having problem in cutting strings. I need a delimiter to cut string.
sample
a.txt
"ID", "1234" , "iam bighippo", "help!"
"ID", "1235" , "again0", "xxxxxxx1"
"ID", "1236" , "again1", "xxxxxxx2"
"ID", "1237" , "again2", "xxxxxxx3"
how do... (6 Replies)
Discussion started by: bighippo
6 Replies
3. Shell Programming and Scripting
Hi all
Iam having a text file of records seperated by "SPACE"
and another text File of Records seperated by "TAB"
i'm writing a Generic code for Extracting Duplicate Records
Iam using "cut" Command to extract data.
How Can I Neglect Delimiter And write a generic code for all cases
... (4 Replies)
Discussion started by: G.Aavudai
4 Replies
4. UNIX for Dummies Questions & Answers
I am having the following file. I need to insert a delimiter in this file. I used sed but its not working.
AAABBB 9 JJJ
AAABBC 9 TTTTT
AAABBA 8 JJJ
AAABBC 7 TTTTT
AAABBC 6 TTTTT
Now i want the output file as:
AAA|BBB| |9| |JJJ|
AAA|BBC| |9| | |TTTTT| (3 Replies)
Discussion started by: sivakumar.rj
3 Replies
5. Shell Programming and Scripting
Hi,
I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies
6. Shell Programming and Scripting
Hi,
I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using... (3 Replies)
Discussion started by: smileyreddy
3 Replies
7. Shell Programming and Scripting
Hi all,
I have a number of strings like below:
//mnt/autocor/43°13'(33")W/
and i'm trying to get the numbers in this string, for example
431333
please help
thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies
8. Shell Programming and Scripting
hi all,
i have a string with a number of "/"s as delimiter.
and i want everything BEFORE the last delimiter
i know to use basename to get everything after the last delimiter.
thx a lot! (2 Replies)
Discussion started by: sunnydanniel
2 Replies
9. Shell Programming and Scripting
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies
10. Shell Programming and Scripting
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Discussion started by: JPB1977
2 Replies
LEARN ABOUT DEBIAN
mysql::diff::table
MySQL::Diff::Table(3pm) User Contributed Perl Documentation MySQL::Diff::Table(3pm)
NAME
MySQL::Diff::Table - Table Definition Class
SYNOPSIS
use MySQL::Diff::Table
my $db = MySQL::Diff::Database->new(%options);
my $def = $db->def();
my $name = $db->name();
my $field = $db->field();
my $fields = $db->fields(); # %$fields
my $primary_key = $db->primary_key();
my $indices = $db->indices(); # %$indices
my $options = $db->options();
my $isfield = $db->isa_field($field);
my $isprimary = $db->isa_primary($field);
my $isindex = $db->isa_index($field);
my $isunique = $db->is_unique($field);
my $isfulltext = $db->is_fulltext($field);
DESCRIPTION
Parses a table definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
Fuller documentation will appear here in time :)
o def
Returns the table definition as a string.
o name
Returns the name of the current table.
o field
Returns the current field definition of the given field.
o fields
Returns an array reference to a list of fields.
o primary_key
Returns a hash reference to fields used as primary key fields.
o indices
Returns a hash reference to fields used as index fields.
o options
Returns the additional options added to the table definition.
o isa_field
Returns 1 if given field is used in the current table definition, otherwise returns 0.
o isa_primary
Returns 1 if given field is defined as a primary key, otherwise returns 0.
o isa_index
Returns 1 if given field is used as an index field, otherwise returns 0.
o is_unique
Returns 1 if given field is used as unique index field, otherwise returns 0.
o is_fulltext
Returns 1 if given field is used as fulltext index field, otherwise returns 0.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
same terms as Perl itself.
SEE ALSO
mysqldiff, MySQL::Diff, MySQL::Diff::Database, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Table(3pm)