move the row of data up or down

jone kim · 09-16-2014, 07:46 PM

I've to shift the row, to put them in a orderd way.

Sample text:
Mark
Male 26 California

Lasi
Female 25 Florida

Andrew
Male 20 Boston

Desired o/p:

Mark Male 26 California
Lasi Female 25 Florida
Andrew Male 20 Boston

What sed/awk command can be used to get the result?

danielbmartin · 09-16-2014, 08:19 PM

With this InFile...

Code:

Mark
Male 26 California

Lasi
Female 25 Florida

Andrew
Male 20 Boston

... this paste ...

Code:

paste -sd"  \n" $InFile >$OutFile

... produced this OutFile ...

Code:

Mark Male 26 California 
Lasi Female 25 Florida 
Andrew Male 20 Boston

Daniel B. Martin

danielbmartin · 09-16-2014, 08:31 PM

With this InFile...

Code:

Mark
Male 26 California

Lasi
Female 25 Florida

Andrew
Male 20 Boston

... this awk ...

Code:

awk '{ol=ol$0" "; if (NF==0) {print ol; ol=""}} END{print ol}' $InFile >$OutFile

... produced this OutFile ...

Code:

Mark Male 26 California 
Lasi Female 25 Florida 
Andrew Male 20 Boston

Daniel B. Martin

jone kim · 09-17-2014, 07:40 PM

Quote:

Originally Posted by danielbmartin

With this InFile...

Code:

paste -sd"  \n" $InFile >$OutFile

Daniel B. Martin

can you please provide explanation of this command "paste -sd" is working?

Thanks!!!

danielbmartin · 09-17-2014, 08:22 PM

Quote:

Originally Posted by jone kim

can you please provide explanation of this command "paste -sd" is working?

When used with the -s option, paste takes a single file and changes the content into one long line.

The individual lines are separated by a tab character by default. If you prefer a different delimiter character, the -d option is used to specify the desired delimiter. Even better, the -d option accepts a character string and uses each of the delimiter string characters in sequence. Coding -d"__\n" directs paste to use a blank, then a blank, then a NewLine character, then another blank, another blank, another NewLine, etc.

The two options -s and -d"__\n" may be combined as -sd"__ \n".

You may better understand this behavior of paste by experimenting with visible delimiter strings. For example, try the same paste with -sd"ABC" and you will see how those delimiter characters are "plugged in" as needed.

Daniel B. Martin

grail · 09-18-2014, 02:21 AM

How about:

Code:

awk 'NF && ORS=(/[0-9]/)?RS:" "' file

syg00 · 09-18-2014, 02:24 AM

Code:

awk '{gsub(/\n/, " ")}1' RS='' names.txt

???

grail · 09-18-2014, 03:23 AM

Well of course you could do that ... sheesh .. hehe

Also:

Code:

awk 'gsub(/\n/, "|")' RS='' file

awk '$1=$1' RS='' FS='\n' OFS=' ' file

pan64 · 09-18-2014, 03:35 AM

what about sed?
sed 'h;N;N;s/\n/ /g'

danielbmartin · 09-18-2014, 07:15 AM

Quote:

Originally Posted by pan64

what about sed?
sed 'h;N;N;s/\n/ /g'

Nice!

Your sed solution reveals an ambiguity in OP's problem statement. I interpreted it to have an input file which does not have a blank last line. In that case your sed fails.

Changing the InFile such that it does have a blank last line, your sed works and my awk fails. However, trusting that the last line is blank permits a shorter, cleaner awk solution...

Code:

awk '{ol=ol$0" "; if (NF==0) {print ol; ol=""}}' $InFile >$OutFile

Daniel B. Martin

firstfire · 09-18-2014, 09:37 AM

Hi.

Here is the solution using ed text editor:

Code:

/tmp$ cat in 
Mark
Male 26 California

Lasi
Female 25 Florida

Andrew
Male 20 Boston
/tmp$ printf "%s\n" 'g/./s/$/ /\' j ,p | ed in
71
Mark Male 26 California

Lasi Female 25 Florida

Andrew Male 20 Boston
?

Number 71 and question mark go to stderr and can be ignored.

This command works as follows.

printf is used to append newline after each argument, for instance:

Code:

$ printf "%s\n" a b c
a
b
c

Actual arguments are commands for ed text editor.

g/./ is the so called global command applied to each non-empty line.
Here is the description from info ed commands:

Quote:

`(1,$)g /RE/COMMAND-LIST'
Global command. Applies COMMAND-LIST to each of the addressed
lines matching a regular expression RE. The current address is set
to the line currently matched before COMMAND-LIST is executed. At
the end of the `g' command, the current address is set to the last
line affected by COMMAND-LIST.

At least the first command of COMMAND-LIST must appear on the same
line as the `g' command. All lines of a multi-line COMMAND-LIST
except the last line must be terminated with a backslash (`\').
Any commands are allowed, except for `g', `G', `v', and `V'. By
default, a newline alone in COMMAND-LIST is equivalent to a `p'
command. If `ed' is invoked with the command-line option `-G',
then a newline in COMMAND-LIST is equivalent to a `.+1p' command.

Our COMMAND-LIST consists of two commands: 1) s/$/ / -- append one space to end of matched line
and 2) j -- join current line with the following one.

Final command ,p prints (p) whole buffer (,) to stdout. We may replace it by the w (write)
command to save changes to file.