sqlplus returning value - remove carriage return '\r'

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove a carriage return at end of variable

Is there a command in unix to remove a carriage return character(^M) at the end of a variable value?

2. UNIX for Dummies Questions & Answers

To remove carriage return between the line

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

3. Shell Programming and Scripting

sqlplus returns leading carriage return into a variable

I am trying to generate some scripts to help manage an Oracle database. When I check the value returned from Oracle it has a leading carriage return in the variable. Is there a way to prevent this? Is there a way to easily strip out the carriage return. See code and output below. ...

4. UNIX for Dummies Questions & Answers

Remove ^M (carriage return) with string manipulation

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...

5. Shell Programming and Scripting

Remove carriage return in a record

6. Shell Programming and Scripting

Awk to remove carriage return from 65th field

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. Shell Programming and Scripting

Remove carriage return from the variable

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...

8. UNIX for Dummies Questions & Answers

Remove carriage return

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...

9. Shell Programming and Scripting

Remove Carriage Return (CRLF) within double quotes

How to remove Carriage Return (CRLF) within double quotes in a file. There are multiple CRLFs within double quotes. We are on Ubuntu 14.04.2 LTS. The file that we are importing is a csv file from unix to windows and the file was formatted to unix2dos. Therefore all lines in the file all have...

10. Shell Programming and Scripting

Remove carriage return and append the next line

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...

LEARN ABOUT SUNOS

setuname

setuname(1M)						  System Administration Commands					      setuname(1M)

NAME

       setuname - change machine information

SYNOPSIS

       setuname [-t] [-n node] [-s name]

DESCRIPTION

       The  setuname  utility  changes the parameter value for the system name and node name. Each parameter can be changed using setuname and the
       appropriate option.

       Either or both the -s and -n options must be given when invoking setuname.

       The system architecture may place requirements on the size of the system and network node name. The command will issue a fatal warning mes-
       sage and an error message if the name entered is incompatible with the system requirements.

OPTIONS

       The following options are supported:

       -n node	       Changes	the node name. node specifies the new network node name and can consist of alphanumeric characters and the special
		       characters dash, underbar, and dollar sign.

       -s name	       Changes the system name. name specifies new system name and can consist of alphanumeric characters and the special  charac-
		       ters dash, underbar, and dollar sign.

       -t	       Temporary change. No attempt will be made to create a permanent change.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       attributes(5)

NOTES

       setuname  attempts  to  change the parameter values in two places: the running kernel and, as necessary per implementation, to cross system
       reboots. A temporary change changes only the running kernel.

SunOS 5.10							    9 Jul 2003							      setuname(1M)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove a carriage return at end of variable

Discussion started by: flagship99

2. UNIX for Dummies Questions & Answers

To remove carriage return between the line

Discussion started by: shash

3. Shell Programming and Scripting

sqlplus returns leading carriage return into a variable

Discussion started by: Panzer993

4. UNIX for Dummies Questions & Answers

Remove ^M (carriage return) with string manipulation

Discussion started by: aquila_1