Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to get rid of "^M" from SQL query

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to get rid of "^M" from SQL query
# 1  
Old 03-21-2007
How to get rid of "^M" from SQL query
I've searched the net and tried various solutions that don't work for me.

I'm trying to return values from a SQL query and I keep getting a "^M" appended to one field.

Code:
 

 Getting data from table 

SELECT * FROM TABLE...
Spooling to $HOME/out.log
...

WF_DATA=`tail -7 $HOME/out.log | awk '{print $1}'`   Assigning the values to WF_DATA variable 

echo  $WF_DATA > $HOME/out.log  Returning the data to out.log ... (May be dumb way but it works.. I need it for formatting purposes 

WF=`tail -1 $HOME/out.log | awk '{print $1}'`  #Getting Workflow
F=`tail -1 $HOME/out.log | awk '{print $2}'`   #Getting Folder
S=`tail -1 $HOME/out.log | awk '{print $3}'`   #Getting Server
U=`tail -1 $HOME/out.log | awk '{print $4}'`   #Getting User
P=`tail -1 $HOME/out.log | awk '{print $5}'`   #Getting Pass

Variable WF is having the "^M" appended to it.

Any suggestions as to how to remove it?

(I tried sed -i '' "s/\r//g" $HOME/out.log (along with other variations) right after the SQL statements and other sections - didn't work)
# 2  
Old 03-21-2007
try something like:
Code:
sed 's/^M//g' logfile

press ctrl key followed by M.
# 3  
Old 03-22-2007
You can get rid of ^M chars by using dos2unix on Solaris/Linux or dos2ux on HP systems. You can add it (required if you intend to open the file in notepad on Windows systems) using unix2dos or ux2dos as above.
# 4  
Old 03-22-2007
Quote:
Originally Posted by ghostdog74
try something like:
Code:
sed 's/^M//g' logfile

press ctrl key followed by M.

It should be ctrl-v followd by m
# 5  
Old 03-22-2007
Or perhaps just replace the awk '{print $1}' to '{printf $1}'
# 6  
Old 03-22-2007
Many Thanks to everyone.

I used matrixmadhan and ghostdog74 suggestions and it worked like a charm.

Great Success
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies

2. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

3. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

6. Shell Programming and Scripting

get rid of "^" character in a .txt file

I have a file that I ran the dos2unix utility on, it cleans up pretty well, but I noticed an occasional ^M leftover, (actual characters) these may or may not be strays from my original dos file. Either way, I want to get rid of the ^ and any character that may follow. ^M ^C or whatever. How do I... (6 Replies)
Discussion started by: ajp7701
6 Replies

7. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

8. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

9. Post Here to Contact Site Administrators and Moderators

How to ged rid of "FeedBot" ?

Hi, how can I ged rid of "FeedBot" postings, put "FeedBot" on an ignore list or remove threads of the "News, Links, Events and Announcements" subforum from the "New Posts" option? Thanks in advance. (5 Replies)
Discussion started by: Ebbi
5 Replies
Login or Register to Ask a Question