Problem in Formatting File

Dhruva · #1 (**permalink**) 04-11-2006

I am facing a very challenging task here but can't finish it.I request all of you to help me please.

I have one file which contain some data i need to format it.
data file contain data like

54321|item-68|owner|yes||||$
00-10|invoice|3221|||#
00-11|invoice|3221|||#
00-12|invoice|3221|||#
book1|032|US|yes|||@

54300|item-68|owner|yes||||$
00-211|invoice|3221|||#
00-113|invoice|3221|||#
00-124|invoice|3221|||#
00-135|invoice|3221|||#
bookdoon|032|US|yes|||@
bookdooner|032|US|yes|||@
......................
......................
.....................

Required format:
54321|item-68|owner|yes||||00-10|invoice|3221|||book1|032|US|yes|||
54321|item-68|owner|yes||||00-11|invoice|3221|||
54321|item-68|owner|yes||||00-12|invoice|3221|||
54300|item-68|owner|yes||||00-1|invoice|3221|||bookdoon|032|US|yes|||
54300|item-68|owner|yes||||0-1|invoice|3221|||book3|032|US|yes|||

lines delimited by # may be more than 4 or less and same for line delimited by @.but line prceded by $ will always be one.
to explain more clearly lets take line preceded by $ is A
by # B
by @ D

we have file like
A$
B#
C#
D#
E@

and i need output in a file like
A B E
A C
A D

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
AWK Formatting Problem	cstovall	Shell Programming and Scripting	2	11-30-2007 10:53 PM
rare problem -reinstalling formatting nothing is working	simaich8	Linux	0	11-04-2007 02:07 AM
Formatting problem	skyineyes	Shell Programming and Scripting	9	07-03-2007 11:11 AM
Formatting Problem	PradeepRed	Shell Programming and Scripting	6	03-16-2007 12:06 PM
Problem re-formatting Disk Partition	jimthompson	UNIX for Dummies Questions & Answers	1	01-11-2006 07:06 AM

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


	Powered by