Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2007-05-30 : 09:44:42
|
| Hi I have a text file which I need to import into Access or SQL.It is 500,000 records which is pipe delimited. The problem is, is that it can contain carriage returns: (square symbol).Therefore I need to find and replace these characters Does anybody know of any free ware text file viewers that can do this??Best RegaredsDavid |
|
|
netedk
Starting Member
11 Posts |
Posted - 2007-06-05 : 11:59:50
|
| You could use TextPadhttp://textpad.com/Once you have it installed, you can use the replace option.Marketing Communications: http://www.realmagnet.comSoftware Development:http://www.daksatech.com |
 |
|
|
caz43
Starting Member
1 Post |
Posted - 2009-06-12 : 18:13:00
|
| I have a question for same topic but in the reverse -- how to create pipe delimited file in sql/access/excel with last field of each record ending in carriage returns rather than a delimiter? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-14 : 13:32:47
|
This should be the normal case.Row delimiter is CR.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
Find and Replace Carriage Return Character