Sponsored Content
Top Forums Shell Programming and Scripting String manipulation row by row Post 302503719 by danmero on Friday 11th of March 2011 11:47:02 AM
Old 03-11-2011
Quote:
Originally Posted by patric2326
And I want to manipulate it to something as shown below:

Code:
_Db._Database                 1023       1      1       1   17.0B     0.2     1.0
_Field._Field-Name                  3       2      2      11   56.2K    64.1     2.0
_Field._Field-Position              4       2      2       8   35.5K    55.7     2.1
_Field._File/Field                  2       2      2      11   47.1K    53.7     2.1

Code:
# awk '{if(NF==1){x=$0;next};sub($1,x"."$1);sub(/[ ]+/,"")}1' file
_Db._Database                 1023       1      1       1   17.0B     0.2     1.0
_Field._Field-Name                  3       2      2      11   56.2K    64.1     2.0
_Field._Field-Position              4       2      2       8   35.5K    55.7     2.1
_Field._File/Field                  2       2      2      11   47.1K    53.7     2.1

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing the column for a row in a text file and adding another row

Hi, I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value . For Eg . if the input file has a row : abc xyz lmn 89 lm nk o p I would like the script to create something like... (9 Replies)
Discussion started by: aYankeeFan
9 Replies

2. Shell Programming and Scripting

remove row if string is same as previous row

I have data like: Blue Apple 6 Red Apple 7 Yellow Apple 8 Green Banana 2 Purple Banana 8 Orange Pear 11 What I want to do is if $2 in a row is the same as $2 in the previous row remove that row. An identical $2 may exist more than one time. So the out file would look like: Blue... (4 Replies)
Discussion started by: dcfargo
4 Replies

3. UNIX for Dummies Questions & Answers

Shell Script: Traverse Database Table Row by Row

Hello Everyone, My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row. I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table. Please help. Thanks &... (5 Replies)
Discussion started by: ahsan.asghar
5 Replies

4. Shell Programming and Scripting

Subtracting each row from the first row in a single column file using awk

Hi Friends, I have a single column data like below. 1 2 3 4 5 I need the output like below. 0 1 2 3 4 where each row (including first row) subtracting from first row and the result should print below like the way shown in output file. Thanks Sid (11 Replies)
Discussion started by: ks_reddy
11 Replies

5. Emergency UNIX and Linux Support

[Solved] Mysql - Take data from row and copy it to another row

Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :( Dear community, I have a table with two rows like: Row1 Row2 ======= ======= 7,3 text 1 1,3 text 2 1,2,3 blabla What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

6. Shell Programming and Scripting

Add Row from First Row (Split Row)

HI Guys, I have Below Input :- RepigA_hteis522 ReptCfiEtrBsCll_aofe MSL04_MSL2_A25_1A 0 9 MSL04_MSL2_A25_1B 0 9 MSL04_MSL2_A25_1C 0 9 RepigA ReptCfiEtrBsCll hteis522 aofe MSL04_MSL2_A25_1A 0 9 MSL04_MSL2_A25_1B 0 9 MSL04_MSL2_A25_1C 0 9 Split Data in two first row... (2 Replies)
Discussion started by: pareshkp
2 Replies

7. UNIX for Beginners Questions & Answers

Keep only the closet match of timestamped row (include headers) from file1 to precede file2 row/s

My original files are like this below and I distinguish them from the AP_ID (file1 has 572 and file2 has 544). Also, the header on file1 has “G_” pre-pended. NOTE: these are only snippets of very large files and much of the data is not present here. Original File 1: ... (36 Replies)
Discussion started by: aachave1
36 Replies

8. Shell Programming and Scripting

Splitting single row into multiple rows based on for every 10 digits of last field of the row

Hi ALL, We have requirement in a file, i have multiple rows. Example below: Input file rows 01,1,102319,0,0,70,26,U,1,331,000000113200000011920000001212 01,1,102319,0,1,80,20,U,1,241,00000059420000006021 I need my output file should be as mentioned below. Last field should split for... (4 Replies)
Discussion started by: kotra
4 Replies

9. UNIX for Beginners Questions & Answers

Keep only the closet match of timestamped row (include headers) from file1 to precede file2 row/s

This is a question that is related to one I had last August when I was trying to sort/merge two files by millsecond time column (in this case column 6). The script (below) that helped me last august by RudiC solved the puzzle of sorting/merging two files by time, except it gets lost when the... (0 Replies)
Discussion started by: aachave1
0 Replies

10. Shell Programming and Scripting

Manipulation row order in file

Hello, I am trying to replace the position of each row by the next row. OS: Ubuntu 18.04, bionic I'd appreciate your help. input_file: -O fileA wget http://x.y.z./a -O fileB wget http://a.b.c./d -O fileC wget http://q.f.s/t .. .. .. -O fileZZ wget http://r.t.y/u I expect: (6 Replies)
Discussion started by: baris35
6 Replies
HTML::FormFu::Filter(3pm)				User Contributed Perl Documentation				 HTML::FormFu::Filter(3pm)

NAME
HTML::FormFu::Filter - Filter Base Class SYNOPSIS
--- elements: - type: Text name: foo filters: - type: Encode candidates: - utf8 - Hebrew - type: Text name: bar filters: - LowerCase - Encode filters: - TrimEdges DESCRIPTION
"filters()" and "filter" can be called on any form, block element (includes fieldsets) or field element. If called on a field element, no "name" argument should be passed. If called on a form or block element, if no "name" argument is provided, a new filter is created for and added to every field on that form or block. See "FORM LOGIC AND VALIDATION" in HTML::FormFu for further details. METHODS
type Returns the "type" argument originally used to create the filter. localise_args Provide arguments that should be passed to localize to replace "[_1]", "[_2]", etc. in the localized string. parent Returns the HTML::FormFu::Element::_Field object that the filter is associated with. get_parent Arguments: \%options Traverses the parent hierarchy, returning the first parent that matches the supplied options. form Returns the HTML::FormFu object that the filter's field is attached to. name Shorthand for "$filter->parent->name" CORE FILTERS
HTML::FormFu::Filter::Callback HTML::FormFu::Filter::CompoundJoin HTML::FormFu::Filter::CompoundSprintf HTML::FormFu::Filter::CopyValue HTML::FormFu::Filter::Default HTML::FormFu::Filter::Encode HTML::FormFu::Filter::FormatNumber HTML::FormFu::Filter::HTMLEscape HTML::FormFu::Filter::HTMLScrubber HTML::FormFu::Filter::LowerCase HTML::FormFu::Filter::NonNumeric HTML::FormFu::Filter::Regex HTML::FormFu::Filter::Split HTML::FormFu::Filter::TrimEdges HTML::FormFu::Filter::UpperCase HTML::FormFu::Filter::Whitespace FILTER BASE CLASSES
The following are base classes for other filters, and generally needn't be used directly. HTML::FormFu::Filter::_Compound AUTHOR
Carl Franks, "cfranks@cpan.org" Based on the original source code of HTML::Widget::Filter, by Sebastian Riedel. LICENSE
This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.14.2 2012-01-23 HTML::FormFu::Filter(3pm)
All times are GMT -4. The time now is 12:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy