Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Using 'sed' to delete or ignore columns in a dataset

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Using 'sed' to delete or ignore columns in a dataset
# 1  
Old 02-29-2008
Using 'sed' to delete or ignore columns in a dataset
Hi,

I've already posted elsewhere but am posting again here coz im a newbie. I hope you forgive me this time.

I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: -

20060714,X.XX,1,043004,Q,T,24.0000,1,25.5000,4,
20060714,X.XX,1,081209,Q,T,24.0000,1,25.5000,5,

As you can see, there are 10 columns here and the table that I am inserting into has 8 columns.

I want to delete the 3rd column (i.e. the 1's) and I want to delete the comma between Q and T. Finally I want to delete the comma at the end.

Is this possible with sed? Can any1 help me with this please?

I'll be extremely grateful if someone can help with this!! You can PM me or post back here.

Many Thanks, asif.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Ignore dollar value in sed

Hi Guys, I need to replace the string based on specific value by keeping dollar sign input=$1 var=$(echo "@code_temp_table_$value_table"| sed -r "s/\@code/${input}/;s/(nz|sa)_\$value_/\$value1_\1_/" ) Expected if input=nz,sa then nz_temp_table_$value1_table else if any other... (5 Replies)
Discussion started by: Master_Mind
5 Replies

2. Shell Programming and Scripting

Selecting random columns from large dataset in UNIX

Dear folks I have a large data set which contains 400K columns. I decide to select 50K determined columns from the whole 400K columns. Is there any command in unix which could do this process for me? I need to also mention that I store all of the columns id in one file which may help to select... (5 Replies)
Discussion started by: sajmar
5 Replies

3. Shell Programming and Scripting

Ignore escape sequence in sed

Friends, In the file i am having more then 100 lines like, File1 had the values like this: #Example East.server_01=EAST.SERVER_01 East.server_01=EAST.SERVER_01 West.server_01=WEST.SERVER_01 File2 had the values like this: #Example EAST.SERVER_01=http://yahoo.com... (3 Replies)
Discussion started by: jothi basu
3 Replies

4. UNIX for Dummies Questions & Answers

Sed: delete columns 7,15,16

An extension from an earlier question. Now need a sed script to delete columns 7,15 and 16 from an example txt below.. Again, thanks in advance. 98M-01.WAV,98M,01,00:00:49,01:07:36:00,"MIX",,"BOOM-MKH50",,,,,,,,,,"", 98L-01.WAV,98L,01,00:00:51,01:01:45:00,"MIX",,"BOOM-MKH50",,,,,,,,,,"", (7 Replies)
Discussion started by: Vrc2250
7 Replies

5. Shell Programming and Scripting

awk based script to ignore all columns from a file which contains character strings

Hello All, I have a .CSV file where I expect all numeric data in all the columns other than column headers. But sometimes I get the files (result of statistics computation by other persons) like below( sample data) SNO,Data1,Data2,Data3 1,2,3,4 2,3,4,SOME STRING 3,4,Inf,5 4,5,4,4 I... (9 Replies)
Discussion started by: ks_reddy
9 Replies

6. Solaris

flarecreate for zfs root dataset and ignore multiple dataset

Hi All, I want to write a script to create flar images on multiple servers. In non zfs filesystem I am using -X option to refer a file to exclude mounts on different servers. but on ZFS -X option is not working. I want multiple mounts to be ignore on ZFS base system during flarecreate. I... (0 Replies)
Discussion started by: uxravi
0 Replies

7. Shell Programming and Scripting

Ignore first word using sed in PERL

Please help me in ignoring first word in a line example Input log 123^Babd^Basdf789^B098^Bouiou Desired output abd,asdf789,098,ouiou 123 should be ignored is this possible using sed regular expressions Use code tags - you got a PM with a guide. (2 Replies)
Discussion started by: thankful123
2 Replies

8. Programming

Extracting differences between two columns dataset (SQL command)

Hi, I have a table in my sqlite, here is an example (tab separated) 585 name1 chr1 + 1872 3533 3533 3533 6 1872,2041,2475,2837,3083,3315, 1920,2090,2560,2915,3237,3533, name2 The 10th and 11th columns have information in a comma separated format (not tab).... (0 Replies)
Discussion started by: labrazil
0 Replies

9. UNIX for Dummies Questions & Answers

Using 'sed' to delete or ignore columns in a dataset

Hi, I want to know if its possible to delete or ignore columns in a large dataset using 'sed'. For example, I have the following dataset: - 20060714,X.XX,1,043004,Q,T,24.0000,1,25.5000,4, 20060714,X.XX,1,081209,Q,T,24.0000,1,25.5000,5, As you can see, there are 10 columns here and the... (4 Replies)
Discussion started by: aarif
4 Replies

10. Shell Programming and Scripting

Make sed ignore lines

Hi I use sed in a script for severall changes in files. I whish one of the substitutions I made to be aplied to every line that has the word "scripts" with the exception for the ones that start with "rsh", wich I wish sed to ignore . Is this possible? If yes, how can I do it? The substitution... (2 Replies)
Discussion started by: Scarlos
2 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

class::makemethods::utility::inheritable

MakeMethods::Utility::Inheritable(3pm)			User Contributed Perl Documentation		    MakeMethods::Utility::Inheritable(3pm)

NAME

       Class::MakeMethods::Utility::Inheritable - "Inheritable" data

SYNOPSIS

	 package MyClass;
	 sub new { ... }

	 package MySubclass;
	 @ISA = 'MyClass';
	 ...
	 my $obj = MyClass->new(...);
	 my $subobj = MySubclass->new(...);

	 use Class::MakeMethods::Utility::Inheritable qw(get_vvalue set_vvalue );

	 my $dataset = {};
	 set_vvalue($dataset, 'MyClass', 'Foobar');    # Set value for class
	 get_vvalue($dataset, 'MyClass');	       # Gets value "Foobar"

	 get_vvalue($dataset, $obj);		       # Objects "inherit"
	 set_vvalue($dataset, $obj, 'Foible');	       # Until you override
	 get_vvalue($dataset, $obj);		       # Now finds "Foible"

	 get_vvalue($dataset, 'MySubclass');	       # Subclass "inherits"
	 get_vvalue($dataset, $subobj); 	       # As do its objects
	 set_vvalue($dataset, 'MySubclass', 'Foozle'); # Until we override it
	 get_vvalue($dataset, 'MySubclass');	       # Now finds "Foozle"

	 get_vvalue($dataset, $subobj); 	       # Change cascades down
	 set_vvalue($dataset, $subobj, 'Foolish');     # Until we override again

	 get_vvalue($dataset, 'MyClass');	       # Superclass is unchanged

DESCRIPTION

       This module provides several functions which allow you to store values in a hash corresponding to both objects and classes, and to retrieve
       those values by searching a object's inheritance tree until it finds a matching entry.

       This functionality is used by Class::MakeMethods::Standard::Inheritable and Class::MakeMethods::Composite::Inheritable to construct methods
       that can both store class data and be overriden on a per-object level.

REFERENCE

   find_vself
	 $vself = find_vself( $dataset, $instance );

       Searches $instance's inheritance tree until it finds a matching entry in the dataset, and returns either the instance, the class that
       matched, or undef.

   get_vvalue
	 $value = get_vvalue( $dataset, $instance );

       Searches $instance's inheritance tree until it finds a matching entry in the dataset, and returns that value

   set_vvalue
	 $value = set_vvalue( $dataset, $instance, $value );

       Searches $instance's inheritance tree until it finds a matching entry in the dataset, and returns that value

perl v5.10.1							    2004-09-06				    MakeMethods::Utility::Inheritable(3pm)