Sponsored Content
Full Discussion: Help with sed Command
Top Forums Shell Programming and Scripting Help with sed Command Post 302900635 by mylife2185 on Thursday 8th of May 2014 02:04:51 AM
Old 05-08-2014
Help with sed Command

I have to rearrange the fields so that the fields are separated by a specific delimiter and come in this order: state, last name, first name, city.

Code:
Mickey Mouse, 1111 Disney Dr., Orlando FL
Minnie Mouse, 1112 Disney Dr., Anaheim CA
Adam Voter, 902 Biscayne Blvd., Miami FL
Zelda Bosco, 4000 State St., Chicago IL
Susie Green, 799 15th St., Indianapolis IN
Tom Furter, 800 N. Walsh St., Milwaukee WI
Dave Ile, 111 W. Illinois Ave., Madison WI
Sam Karter, 1400 E. 57th St., Los Angeles CA
Howard Messer, 5957 W. 157th St., Orland Park IL
Ogden Nash, 2800 S. Lake St., Berkeley IL
Penelope Ogden, 1527 W. Aurora Rd., Naperville IL
Harvey Pelican, 800 N. Lake Shore Dr. #134, Michigan City IN
Tawanda Rice, 1027 Belmont Place, West Palm Beach FL
Kendall Smith, 2231 W. 13th St., Madison WI
Byron Trapp, 5 S. Maple Dr., Indianapolis IN
Milton Callahan, 333 Cordoba Rd., Schaumburg IL
Dominique Daniels, 771 W. 77th Ct., Gary IN
Vickie Edison, 14251 W. Central, Milwaukee WI
Gandalf Addison, 200 Palm Drive, Jupiter FL
Gollum Zeller, 908 Martin Pl., Tampa FL
Jenilee Harrison, 511 River Rd., San Francisco CA
Waylon Jetson, 111 Skyway Dr., Green Bay WI

But it have to look like this...

Code:
FL:Mouse:Mickey:Orlando
CA:Mouse:Minnie:Anaheim
FL:Voter:Adam:Miami
IL:Bosco:Zelda:Chicago
IN:Green:Susie:Indianapolis
WI:Furter:Tom:Milwaukee
WI:Ile:Dave:Madison
CA:Karter:Sam:Los Angeles
IL:Messer:Howard:Orland Park
IL:Nash:Ogden:Berkeley
IL:Ogden:Penelope:Naperville
IN:Pelican:Harvey:Michigan City
FL:Rice:Tawanda:West Palm Beach
WI:Smith:Kendall:Madison
IN:Trapp:Byron:Indianapolis
IL:Callahan:Milton:Schaumburg
IN:Daniels:Dominique:Gary
WI:Edison:Vickie:Milwaukee
FL:Addison:Gandalf:Jupiter
FL:Zeller:Gollum:Tampa
CA:Harrison:Jenilee:San Francisco
WI:Jetson:Waylon:Green Bay

I'm using Unix/Linux for the first time and i'm really having problems can you help me. Thank You

Last edited by Scrutinizer; 05-08-2014 at 03:07 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Sorry for the duplicate thread this one is similar to the one in https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121 Since there were no responses on the parent thread since it got resolved partially i thought to open the new... (4 Replies)
Discussion started by: rajan_san
4 Replies

2. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

Okay, title is kind of confusion, but basically, I have a lot of scripts on a server that I need to replace a ps command, however, the new ps command I'm trying to replace the current one with pipes to sed at one point. So now I am attempting to create another script that replaces that line. ... (1 Reply)
Discussion started by: cbo0485
1 Replies

3. UNIX for Dummies Questions & Answers

some help with the sed command please

hi all, attached you can find a small txt file ( .txt ), GIVEN that past_scheduler="islip" and scheduler="mucf" can somebody please tell me WHY sed 's/-u '$past_scheduler'/-u '$scheduler'/g' .txt > .txt.temp fails ? thanx (3 Replies)
Discussion started by: OneDreamCloser
3 Replies

4. Shell Programming and Scripting

Convert Sed command to perl command

Hello, Can any perl experts help me convert my sed string to perl. I am unsuccessful with this. I have to remove this string from html files OAS_AD('Top'); I have come up with this. However the requirement is in perl. for find in $(find . -type f -name "file1.html") ; do cat $find |... (2 Replies)
Discussion started by: abacus
2 Replies

5. UNIX for Dummies Questions & Answers

sed insert command and variable expansion/command substitution

I know this script is crummy, but I was just messing around.. how do I get sed's insert command to allow variable expansion to show the filename? #!/bin/bash filename=`echo $0` /usr/bin/sed '/#include/ { i\ the filename is `$filename` }' $1 exit 0 (8 Replies)
Discussion started by: glev2005
8 Replies

6. UNIX for Advanced & Expert Users

sed command

Hi..... I'm using sed command for replace the words in a file cat >test.txt My test.txt contains Mary had a little ham Mary fried a lot of spam Jack ate a Spam sandwich Jill had a lamb spamwich Marry had a spicy wich $ sed 's/wich$/mirchi/g' test.txt output is: Mary had a little ham... (24 Replies)
Discussion started by: ksrivani
24 Replies

7. Shell Programming and Scripting

sed returns error "sed: -e expression #1, char 18: unterminated `s' command"

Hello All, I have something like below LDC100/rel/prod/libinactrl.a LAA2000/rel/prod/libinactrl.a I want to remove till first forward slash that is outputshould be as below rel/prod/libinactrl.a rel/prod/libinactrl.a How can I do that ??? (8 Replies)
Discussion started by: anand.shah
8 Replies

8. Shell Programming and Scripting

sed Command

Hello, I'm working with this command which I'm having trouble understanding it: sed -e '1,$ s/SUB/N/g' < $1 > file.txt Where SUB stand for an special character with code in ASCII is 0x1A, notepad read it as a right arrow. Any help will be appreciated. (5 Replies)
Discussion started by: emilioveras
5 Replies

9. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

Hi, I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :- ./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies

10. UNIX for Dummies Questions & Answers

Output of sed command to another sed command

Hi All, I'm relatively new to Unix scripting and am trying to get my head around piping. I'm trying to take a header record from one file and prepend it to another file. I've done this by creating several temp files but i'm wondering if there is a cleaner way to do this. I'm thinking... (10 Replies)
Discussion started by: BigCroyd
10 Replies
HTML::FormHandler::Field::Repeatable(3pm)		User Contributed Perl Documentation		 HTML::FormHandler::Field::Repeatable(3pm)

NAME
HTML::FormHandler::Field::Repeatable - repeatable (array) field VERSION
version 0.40013 SYNOPSIS
In a form, for an array of hashrefs, equivalent to a 'has_many' database relationship. has_field 'addresses' => ( type => 'Repeatable' ); has_field 'addresses.address_id' => ( type => 'PrimaryKey' ); has_field 'addresses.street'; has_field 'addresses.city'; has_field 'addresses.state'; In a form, for an array of single fields (not directly equivalent to a database relationship) use the 'contains' pseudo field name: has_field 'tags' => ( type => 'Repeatable' ); has_field 'tags.contains' => ( type => 'Text', apply => [ { check => ['perl', 'programming', 'linux', 'internet'], message => 'Not a valid tag' } ] ); or use 'contains' with single fields which are compound fields: has_field 'addresses' => ( type => 'Repeatable' ); has_field 'addresses.contains' => ( type => '+MyAddress' ); If the MyAddress field contains fields 'address_id', 'street', 'city', and 'state', then this syntax is functionally equivalent to the first method where the fields are declared with dots ('addresses.city'); You can pass attributes to the 'contains' field by supplying a 'contains' hashref. has_field 'addresses' => ( type => 'Repeatable, init_contains => { wrapper_attr => { class => ['hfh', 'repinst'] } }, ); DESCRIPTION
This class represents an array. It can either be an array of hashrefs (compound fields) or an array of single fields. The 'contains' keyword is used for elements that do not have names because they are not hash elements. This field node will build arrays of fields from the the parameters or an initial object, or empty fields for an empty form. The name of the element fields will be an array index, starting with 0. Therefore the first array element can be accessed with: $form->field('tags')->field('0') $form->field('addresses')->field('0)->field('city') or using the shortcut form: $form->field('tags.0') $form->field('addresses.0.city') The array of elements will be in "$form->field('addresses')->fields". The subfields of the elements will be in a fields array in each element. foreach my $element ( $form->field('addresses')->fields ) { foreach my $field ( $element->fields ) { # do something } } Every field that has a 'fields' array will also have an 'error_fields' array containing references to the fields that contain errors. Complications When new elements are created by a Repeatable field in a database form an attempt is made to re-load the Repeatable field from the database, because otherwise the repeatable elements will not have primary keys. Although this works, if you have included other fields in your repeatable elements that do *not* come from the database, the defaults/values must be able to be loaded in a way that works when the form is initialized from the database item. This is only an issue if you re-present the form after the database update succeeds. ATTRIBUTES
index This attribute contains the next index number available to create an additional array element. num_when_empty This attribute (default 1) indicates how many empty fields to present in an empty form which hasn't been filled from parameters or database rows. num_extra When the field results are built from an existing object (item or init_object) an additional number of repeatable elements will be created equal to this number. Default is 0. add_extra When a form is submitted and the field results are built from the input parameters, it's not clear when or if an additional repeatable element might be wanted. The method 'add_extra' will add an empty repeatable element. $form->process( params => {....} ); $form->field('my_repeatable')->add_extra(1); This might be useful if the form is being re-presented to the user. AUTHOR
FormHandler Contributors - see HTML::FormHandler COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Gerda Shank. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.14.2 2012-06-25 HTML::FormHandler::Field::Repeatable(3pm)
All times are GMT -4. The time now is 07:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy