Sponsored Content
Full Discussion: unconstant delimiter
Top Forums UNIX for Dummies Questions & Answers unconstant delimiter Post 302553892 by tsurendra on Friday 9th of September 2011 06:00:55 AM
Old 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

replace the last delimiter

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

from - to delimiter

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

How To Neglect Delimiter

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

Delimiter

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

Substring based on delimiter, finding last delimiter

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

Help regarding the delimiter

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

How to cut by delimiter, and delimiter can be anything except numbers?

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

how to get everything before the last delimiter?

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

Shell script to put delimiter for a no delimiter variable length text file

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

Perl Code to change file delimiter (passed as argument) to bar delimiter

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
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)
All times are GMT -4. The time now is 04:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy