Cut determinate values amb subst for ;

capilla · #1 10-02-2012

Hello
I have a output file that contains the next info:

Code:

host_name   LET-234-WDFD-2
 address    10.11.0.62
 host_name   XWERWE-234-WEDF-EMEEH-GIDF-3
 address    10.11.32.48
 host_name   DFG-745-WE-EMEEEH-GIDF-4
 address    10.11.32.176
        host_name                       DFDFG-ERWG-BL-ETH-01-FV
        address                         198.18.1.107
        host_name                       DFDFG-ERWG-BL-ETH-02-FV
        address                         198.18.1.108
        host_name                       DFDFG-WEFEW-WEFWEF-01-ASDS
        address                         10.11.0.108
 host_name   DFDFG-SDF-UKLY-01-FGG
 address    198.18.253.138
 host_name   DFDFG-SDF-UKLY-02-FGG
 address    198.18.253.139
 host_name   DFDFG-SDF-UKLY-01-GGHTFGH2

elixir_sinari · #2 10-02-2012

Assuming a space between the strings and the data,try:

Code:

cut -d' ' -f2- file|paste -sd';\n'

vgersh99 · #3 10-02-2012

Code:

awk 'FNR%2 {print name, $2;next}{name=$2}' OFS=';' myFile

capilla · #4 10-03-2012

Hello Thanks for your reply. I try with the metodes and doesn't work :-(. The result is:

Code:

cut -d' ' -f2- file|paste -sd';\n' extractcritiques.txt
 host_name       cedf-ddt              ;       address         10.14.138.3
        host_name       dfb-crft             ;       address         10.14.184.2
        host_name       cesdneb-cerferu             ;       address         10.14.184.3
        host_name       cenfeeb-derfx;     address         10.14.139.10

Scrutinizer · #5 10-03-2012

Slight mod to vgersh's awk:

Code:

awk 'FNR%2 {name=$2; next} {print name, $2}' OFS=';' infile

capilla · #6 10-03-2012

Thankss!!!!
When I read your reponse I'm try with:

Quote:

awk 'FNR%2 {name=$2}{print name, $2;next}' OFS=';

You win

RudiC · #7 10-03-2012

small corrections to the suggestions will make them work.
1) remove excess spaces using sed:

Code:

sed 's/  */ /g;s/^ //' extractcritiques.txt|cut -d' ' -f2- |paste -sd';\n'

Thread Tools	Search this Thread
Show Printable Version Email this Page Subscribe to this Thread	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
A simple variable subst is not working	IMPe	Shell Programming and Scripting	1	06-01-2012 08:49 AM
Compare values in two files. For matching rows print corresponding values from File 1 in File2.	Santoshbn	Shell Programming and Scripting	10	05-21-2012 11:23 AM
Delete character in determinate position with sed/awk	maria_florencia	Shell Programming and Scripting	4	01-20-2011 10:01 AM
assign subst\|grep\|sed command result to a variable	snowbiker99	Shell Programming and Scripting	5	11-14-2007 06:08 PM
Command param subst to reg expression	videsh77	Shell Programming and Scripting	5	12-21-2004 01:46 PM

The Following User Says Thank You to Scrutinizer For This Useful Post:
capilla (10-03-2012)

The Following User Says Thank You to RudiC For This Useful Post:
capilla (10-03-2012)