08-03-2011
Remove carriage return in a record
Hi all gurus,
I need help in removing carriage return existed within a record delimited by pipe <|>.
Sample:
A_01|Test1|Testing1|Remarks1
A_02|Test2|Test
ing2|Remarks2
A_03|Test3|Testing3|
Remarks3
Desire output:
A_01|Test1|Testing1|Remarks1
A_02|Test2|Testing2|Remarks2
A_03|Test3|Testing3|Remarks3
I came across the thread in removing carriage return as below,
https://www.unix.com/shell-programmin...ging-data.html
but it is looking for keywords ADD,MODIFY,DELETE
Need your help on this matter. Thanks alot.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file with multiple records in it and want to create a single record by removing all the carriage returns, is there a sed command or another command that will easily allow this to happen.
current layout
813209A
813273C
812272B
expected result
813209A813273C812272B
previously I... (3 Replies)
Discussion started by: r1500
3 Replies
2. UNIX for Dummies Questions & Answers
Is there a command in unix to remove a carriage return character(^M) at the end of a variable value? (5 Replies)
Discussion started by: flagship99
5 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have a situation where I need to remove the carriage return between the lines.
For.eg.
The input file:
1,ad,"adc
sdfd",edf
2,asd,"def
fde",asd
The output file should be
1,ad,adc sdfd,edf
2,asd,def fde,asd
Thanks
Shash (5 Replies)
Discussion started by: shash
5 Replies
4. Shell Programming and Scripting
Guys - Simple code, i am trying to get a number back from sqlplus call to a query. After that, i need to use that number in a loop.
---------------------------------
#!/bin/ksh
VALUE=`sqlplus -silent sh/password@sh <<END
set pagesize 0 feedback off verify off heading off echo off
select... (10 Replies)
Discussion started by: sunshine1974
10 Replies
5. UNIX for Dummies Questions & Answers
Hello, I want remove ^M at end of my files line
if I use command : tr -d '\r' <inp>out it work fine
but get I the same result by manipulating the string ?
I want this because in my text file I manipulate some other part
I have input "the cat^M"
I want output "the cat"
I have made... (3 Replies)
Discussion started by: aquila_1
3 Replies
6. Shell Programming and Scripting
Hi all,
need your help in replacing carriage return in a record.
Input:
col1|col2|col3|col4|col5|col6|col7|col8|col9|col10
1|aa|bb|cc|dd|eee
eee|ff|ggggg|hh
hhh|iii
2|zz|yy|xx|ww|vv|uu|tt|ss|rr
Output:
col1|col2|col3|col4|col5|col6|col7|col8|col9|col10... (12 Replies)
Discussion started by: agathaeleanor
12 Replies
7. Shell Programming and Scripting
Hi,
I have a pipe delimited file. There are around 700 columns in the file.
The 65th column has carriage return which is causing read issue with our ETL process. I would like to replace the new line characters in 65th field with "nothing"
i have return the following code and need help to... (7 Replies)
Discussion started by: pinnacle
7 Replies
8. Shell Programming and Scripting
Hi,
I try to handle very large numbers with a bash script. I run ssh command in a remote server and store the output in a local variable. But this output contains a return carriage at the end. So I try to remove it by tr But I can't figure out the right notation with printf. So my problem... (6 Replies)
Discussion started by: Meacham12
6 Replies
9. UNIX for Dummies Questions & Answers
I need to remove the carriage return comes inbetween the record.
Need to have CR only at the end.
I used the below command.
tr -d '\n' < filewithcarriagereturns > filewithoutcarriagereturns
But its removing all the CR and giving one line output.
Input File:
12345
abcdegh... (11 Replies)
Discussion started by: srvn_saru
11 Replies
10. Shell Programming and Scripting
Hi All,
My requirement is to remove the carriage return in from the lines which i am reading if the length is lesser than 1330 and append the next line with it. Below is the realistic example of file structure.
Input file:
Blah blah blah blah Blah blah blah blah
Blah blah blah blah Blah... (16 Replies)
Discussion started by: mad man
16 Replies
LEARN ABOUT OPENSOLARIS
purple-url-handler
purple-url-handler(1) User Commands purple-url-handler(1)
NAME
purple-url-handler - Python script to handle URL with purple
SYNOPSIS
purple-url-handler [-URL]
DESCRIPTION
Python script to handle URL with purple.
OPTIONS
Usage: purple-url-handler URL
Example:
purple-url-handler "xmpp:romeo@montague.net?message"
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-im-client |
+-----------------------------+-----------------------------+
|Interface stability |Volatile |
+-----------------------------+-----------------------------+
SEE ALSO
purple-remote(1), purple-send(1), purple-send-async(1), attributes(5)
purple-url-handler Manual, http://pidgin.im/
NOTES
Updated by Lei Ju, Sun Microsystems Inc., 2006, 2007.
SunOS 5.11 02 Apr 2008 purple-url-handler(1)