943,879 Members | Top Members by Rank

Ad:
Nov 12th, 2008
0

newbie question - sorting a vertical list into a csv format

Expand Post »
Hi guys, I'm looking to start scripting and have a problem I thought I would use to learn some basics, basically I have a list of my family's addresses that are in one big vertical list varying in size. I want to sort into a tabular format below is a example of the list

I'm looking into how to sort through a list, and print each element into a line under the right category heading (using comma's as a separator) then using a blank as a prompt for the script to move onto the next bunch of data in the list (in this case contact details) putting that on a new line

Thanks in advance

bob smith
43 canarvon road
worcester
WD2 4 XY
Tel:0800 000 000
Email:get@me.co.uk

john doe
56 victoria street
little hampton
hamtonshire
Email:the@there.com

lilly allen
94 Dames close
Simsville
Essex
Phone:0909811811

I would like to sort it as follows(csv format):
name, address1, address2, address3, address4, email, phone
bob smith, 43 canarvon road, worcester, WD2 4 XY, , Email:get@me.co.uk, Tel:0800 000 000
john doe, 56 victoria street, little hampton, hamtonshire, ,the@there.com, ,
lilly allen, 94 Dames close, Simsville, Essex,,, Phone:0909811811
Last edited by c7borg; Nov 12th, 2008 at 11:30 am.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
c7borg is offline Offline
2 posts
since Nov 2008
Nov 13th, 2008
0

Re: newbie question - sorting a vertical list into a csv format

sounds like homework to me!! You had a go at it at all. You should try man sed.
Reputation Points: 38
Solved Threads: 15
Posting Pro in Training
chris5126 is offline Offline
412 posts
since Feb 2006
Nov 13th, 2008
0

Re: newbie question - sorting a vertical list into a csv format

Click to Expand / Collapse  Quote originally posted by chris5126 ...
sounds like homework to me!! You had a go at it at all. You should try man sed.
no not at my age.. but I will have a look at the manual
Reputation Points: 10
Solved Threads: 0
Newbie Poster
c7borg is offline Offline
2 posts
since Nov 2008
Nov 13th, 2008
0

Re: newbie question - sorting a vertical list into a csv format

lol sorry just have seen very similar if not exactly the same problem before!! Look through this forum and you should find the answer somewhere.
Reputation Points: 38
Solved Threads: 15
Posting Pro in Training
chris5126 is offline Offline
412 posts
since Feb 2006
Nov 14th, 2008
0

Re: newbie question - sorting a vertical list into a csv format

Click to Expand / Collapse  Quote originally posted by chris5126 ...
lol sorry just have seen very similar if not exactly the same problem before!! Look through this forum and you should find the answer somewhere.
(while read line; do if [ $(echo $line | wc -c) -eq 1 ] ; then echo; else echo -n $line,; fi ; done<address.txt ) |sort >address.csv
Reputation Points: 53
Solved Threads: 33
Posting Whiz in Training
bugmenot is offline Offline
224 posts
since Nov 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Shell Scripting Forum Timeline: Hey
Next Thread in Shell Scripting Forum Timeline: Change DNS from DHCP to static in Ubuntu





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC