formatting text using awk

Question

Hi I have the following text and I need to use awk or sed to print 3 separate columns

11/13/14    101 HUDSON AUBONPAINJERSEY CITY NJ      $4.15
11/22/14    MTAMVM*110TH ST/CATNEW YORK NY          $19.05
11/22/14    DUANE READE #14226 0NEW YORK NY         $1.26

So I like to produce a file containing all the dates. Another file containing all the description and third file containing all the numbers

I can use an awk to print the first column printy $1 and then use -F [$] option to print last column but I'm not able to just print the middle column as there are spaces etc. Can I ignore the spaces? or is there a better way of doing this?

Thaking you in advance

Gilles Quénot · Accepted Answer · 2015-01-07 00:53:07Z

5

Try doing this :

 $ awk '
     {
         print $1 > "dates"; $1=""
         print $NF > "prices"; $NF=""
         print $0 > "desc"
     }
' file

or :

awk -F'  +' '
    {
        print $1 > "dates"
        print $2 > "desc"
        print $3 > "prices"
    }
' file

Then :

$ cat dates
$ cat desc
$ cat prices

edited Jan 7, 2015 at 0:53

answered Jan 6, 2015 at 23:06

Gilles Quénot

188k43 gold badges232 silver badges229 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gilles Quénot Over a year ago

Added another awk solution

buydadip · Accepted Answer · 2015-01-06 23:27:14Z

0

Wasn't fast enough to be the first to give an awk solution, so here's one with grep and sed...

grep -o '^.*/.*/1.' file   #first col
sed 's/^.*\/.*\/1.//;s/\$.*//' file   #middle col
grep -o '\$.*$' file    #last col

edited Jan 6, 2015 at 23:27

answered Jan 6, 2015 at 23:21

buydadip

9,48722 gold badges93 silver badges160 bronze badges

Collectives™ on Stack Overflow

formatting text using awk

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related