Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove Carriage Returns 1

Status
Not open for further replies.
borisbe

borisbe

Technical User
Aug 15, 2005
73
US
I have a text file with email addresses that I'm importing into a table and there are carriage returns after each email address which is causing problems. Is it possible to remove the carriage returns using a query?

Thanks
 
Sort by date Sort by votes
Sure. After you import the text file, do:
[tt]
UPDATE tbl SET email=REPLACE(email,'\n','')
[/tt]
 
Upvote 0 Downvote
You have saved the day. Thank you so much. It worked wonderfully.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

koresnordic
  • Locked
  • Question
Remove quotes inside a text field
Replies
8
Views
152
koresnordic
koresnordic
miller55
  • Locked
  • Question
Remove specific links
Replies
1
Views
54
ChrisHirst
ChrisHirst
vishalonne
  • Locked
  • Question
SQL Query returns records which is not required
Replies
1
Views
73
towerbase
towerbase
alohaaaron
  • Locked
  • Question
query returns unwanted duplicates
Replies
0
Views
51
alohaaaron
alohaaaron
Dieuz
  • Locked
  • Question
Remove duplicated row
Replies
1
Views
36
towerbase
towerbase

Part and Inventory Search

Sponsor

Back
Top