49

I have simple text file named "example".

Reading with terminal command: cat example

Output:

abc cdef ghi jk lmnopq rst uv wxyz

I want to convert (transform) into following form: (expected output from cat example)

abc
cdef
ghi
jk
lmnopq
rst
uv
wxyz

How can I do this via the command-line?

(This is only an example file, I want to convert word's position in vertical-column)

Pandya
  • 37,289

6 Answers6

83

A few choices:

  1. The classic, use tr:

    tr ' ' '\n' < example
    
  2. Use cut

    cut -d ' ' --output-delimiter=$'\n' -f 1- example
    
  3. Use sed

    sed 's/ /\n/g' example
    
  4. Use perl

    perl -pe 's/ /\n/g' example
    
  5. Use the shell

    foo=$(cat example); echo -e "${foo// /\\n}"
    
terdon
  • 104,119
17

Try the below command:

awk -v RS=" " '{print}' file

Or:

awk -v RS='[\n ]' '{print}' file

Example:

$ awk -v RS=" " '{print}' example
abc
cdef
ghi
jk
lmnopq
rst
uv
wxyz

Explanation:

RS (Record Separator) is a built-in awk variable. In the first command, the value given to the RS variable is space (" "). awk breaks the line from printing whenever it finds a space.

In the second command, the value given to the RS variable is a new line character or space ('[\n ]'). This command eliminates the extra blank line that appears when running the first command.

Avinash Raj
  • 80,446
15

You can use xargs,

cat example | xargs -n 1

or, better

xargs -n 1 < example
sourav c.
  • 46,120
3

Using a perl oneliner:

perl -p -i -e 's/\s/\n/g' example

It will replace spaces and tabs with "ENTER" (aka \n)

3

No one posted python, so here's that:

python -c "import sys;lines=['\n'.join(l.strip().split()) for l in sys.stdin.readlines()];print('\n'.join(lines))" < input.txt 

We redirect input file into python's stdin stream, and read it line by line. Each line is stripped of its trailing newline, split into words, and then rejoined into one string where each word is separated by newline.This is done to ensure having one word per line and avoid multiple newlines being inserted in case there's multiple spaces next to each other. Eventually we end up with list of strings, which is then again joined into larger string, and printed out to stdout stream. That later can be redirected to another file with > out.txt redirection.

2

Similar to the tr in @terdon's answer, but with the additions:

  • Also works for tabs

  • Converts multiple spaces or tabs to 1 newline

tr -s '[:space:]' '\n' < example
AstroTom
  • 121