06-07-2006
Convert a paragraph to single line
I need to check the count of pipes on each line of the data to make sure we 4 pipes if its less i need to keep adding the string to form a single line ( Need to join/ concat the below lines until i get the 4 pipes which is end of record ). This fields is basicall a memo where the user would have typed a small paragraph that needs to be joined into a single line.
Sample Broken Lines and data
-----------------------------
467|Computer Monitor|Purchase Prise $150
Best Price $100
Cheapest Price $75
highest price $200|T|
Correct record would look like this
467|Computer Monitor|Purchase Prise $150 Best Price $100 Cheapest Price $75 highest price $200|T|
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Have another question that has been eluding me all day.
I have data file I'm trying to reformat so that each line is appended with an ID code, but the ID code needs to update as it searches through the file.
I.e.
----Begin Original Datafile-----
Condition = XXX
Header Line 1
Header... (1 Reply)
Discussion started by: selkirk
1 Replies
2. Shell Programming and Scripting
i would like to ask how to make a script that in evry 3 lines of my paragraph(below) it would appear like this:
$ cat myparagraph
this is line 1
this is line 2
this is line3
this is line 4
this is 5
this 6
this is 7
this 8
====================================================
$ cat... (2 Replies)
Discussion started by: invinzin21
2 Replies
3. Shell Programming and Scripting
hi all, iam new to awk & sed cmd and appreacite help from all the script expert from this forum, i have a file like below:
Fri Aug 01 00:01:19 2008
NAS-IP-Address = 172.16.160.1
Class = "P1-SHT-AAA01;1217116976;70999"
Calling-Station-Id = "00-11-FB-01-03-06"
Acct-Status-Type = Start... (13 Replies)
Discussion started by: xajax7
13 Replies
4. Shell Programming and Scripting
Hi everybody,
Say I have a file that looks like this:
How could I print a new file with only the first lines of each paragraph: (3 Replies)
Discussion started by: thedude
3 Replies
5. Shell Programming and Scripting
Hi all,
May you help me with this?
After extract only some lines that I need from a file, I would like to concatenate the remaining lines in a single line (paragraph).
Source file pattern:
Event Type: Warning
Event Source: Sorting
Event Category: None
Event ID: 1188
Date: 9/10/2008... (4 Replies)
Discussion started by: cgkmal
4 Replies
6. UNIX for Advanced & Expert Users
Hi
I want to convert multiple rows ro single row ,I have tried with below one but I am not getting what I am expecting.Please any idea
a.txt
conn1=stg
conn2=dev
path=\xxx\a1.txt
fre=a
conn1=stg
conn2=dev
path=\xxx\a2.txt
freq=a
awk '/a/{ORS=" "}{print}END{print "\n"}'... (5 Replies)
Discussion started by: akil
5 Replies
7. Shell Programming and Scripting
Hi all,
The following lines are taken from a long paragraph:
Labels of output orbitals: RY* RY* RY* RY* RY* RY*
1\1\GINC-COMPUTE-1-3\SP\UB3LYP\6-31G\C2H5Cr1O1(1+,5)\LIUZHEN\19-Jan-20
10\0\\# ub3lyp/6-31G pop=(nbo,savenbo) gfprint\\E101GECP\\1,5\O,0,-1.7
... (1 Reply)
Discussion started by: liuzhencc
1 Replies
8. Shell Programming and Scripting
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies
9. Shell Programming and Scripting
Hi all,
I have a single line output like below
echo $ips
10.26.208.28 10.26.208.26 10.26.208.27
want to convert above single line output as below format. Pls advice how to do ?
10.26.208.28
10.26.208.26
10.26.208.27
Regards
Kannan (6 Replies)
Discussion started by: kamauv234
6 Replies
10. Shell Programming and Scripting
I need to search the file using strings "Request Type" , " Request Method" , "Response Type" and by using result set find the xml tags and convert into a single line?. below are the scenarios.
Cat test
Nov 10, 2012 5:17:53 AM
INFO: Request Type
Line 1.... (5 Replies)
Discussion started by: laknar
5 Replies
LEARN ABOUT HPUX
streampipes
streampipes(5) File Formats Manual streampipes(5)
NAME
streampipes - force all pipes to be STREAMS-based
VALUES
Failsafe
Default
Allowed values
Recommended values
DESCRIPTION
This tunable determines the type of pipe that is created by the system call. If set to the default value of zero, all pipes created by are
normal HP-UX file-system pipes. If the value is non-zero, creates STREAMS-based pipes, and STREAMS modules can be pushed onto the result-
ing stream.
If this tunable is set to a non-zero value, the and module and driver must be configured in file
Who Is Expected to Change This Tunable?
Any customer.
Restrictions on Changing
Changes to this tunable take effect at next reboot.
When Should the Tunable Be Turned On?
If the customer uses applications that require STREAMS-based pipes, this tunable should be turned on.
What Are the Side Effects of Turning the Tunable On?
STREAMS-based pipes performance may differ from normal file system pipes.
When Should the Tunable Be Turned Off?
If the customer does not need the STREAMS-based pipes, this tunable should be turned off.
What Are the Side Effects of Turning the Tunable Off?
Applications that try to push STREAMS modules onto the pipe will fail.
What Other Tunable Should Be Changed at the Same Time as This One?
If this tunable is set to a non-zero value, the and module and driver must be configured in the file
WARNINGS
All HP-UX kernel tunable parameters are release specific. This parameter may be removed or have its meaning changed in future releases of
HP-UX.
Installation of optional kernel software, from HP or other vendors, may cause changes to tunable parameter values. After installation,
some tunable parameters may no longer be at the default or recommended values. For information about the effects of installation on tun-
able values, consult the documentation for the kernel software being installed. For information about optional kernel software that was
factory installed on your system, see at
AUTHOR
was developed by HP.
Tunable Kernel Parameters streampipes(5)