472,353 Members | 1,490 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

How to remove the CR character (□)

I have imported large text fields from Excel into Access 2000 which
contain many repetitions of the Carriage Return character similar to
"□".

How can I strip them out without doing it manually? The Find and
Replace function does not work as it does not recognize this character.

Thanks in advance for any advice.

Peter Tyler

Nov 13 '05 #1
7 8413
I'm sorry I cant help here Peter but I will be interested in seeing your
replies.
I have a similar problem with an address field. In the past CR's were put
in to correctly format the field for print. It has now become necessary to
print the addresses at 30 degrees due to the envelope template we are using.
I have found a VB procedure which can do this but unlike Access it doesn't
recognise the "?" character return.
Ideally I would like to replace the "?" with a traditional CR symbol
(whatever that may be).

"Peter Tyler" <PL*****@gmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
I have imported large text fields from Excel into Access 2000 which
contain many repetitions of the Carriage Return character similar to
"?".

How can I strip them out without doing it manually? The Find and
Replace function does not work as it does not recognize this character.

Thanks in advance for any advice.

Peter Tyler

Nov 13 '05 #2
I do know that Word can find & replace that character, so you might try
cleaning up the text file in Word, then importing the text/csv file into
Access. Visual basic uses "vbCr" or "Chr(13)" to represent carriage
returns.
-Ed

"Peter Tyler" <PL*****@gmail.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...
I have imported large text fields from Excel into Access 2000 which
contain many repetitions of the Carriage Return character similar to
"?".

How can I strip them out without doing it manually? The Find and
Replace function does not work as it does not recognize this character.

Thanks in advance for any advice.

Peter Tyler
Nov 13 '05 #3
rkc
Peter Tyler wrote:
I have imported large text fields from Excel into Access 2000 which
contain many repetitions of the Carriage Return character similar to
"□".

How can I strip them out without doing it manually? The Find and
Replace function does not work as it does not recognize this character.

Thanks in advance for any advice.


Try running an update query on a copy of the table using the replace
function and see how things go.

UPDATE Table
SET ImportField = Replace([ImportField],Chr$(13) ,"");
Nov 13 '05 #4
>>UPDATE Table
SET ImportField = Replace([ImportField],Chr$(13) ,"")

Thanks. Daunting, but I'll give it a try!

Peter

Nov 13 '05 #5
Thanks for your response Ed.

Peter

Nov 13 '05 #6
Tried it out in Word 2002 but it doesn't find the "□" character nor
does it treat the character as a manual line feed.

Peter

Nov 13 '05 #7
OK, I've done it. I dropped the Access column with the offending text
(about 800 records) back into Excel and ran the Clean() function, which
strips out "non-printable" characters, then copied it back into Access.
Works a treat!

Thanks for everybody's input.

Peter Tyler

Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Hans Stoessel | last post by:
Hi I have a C application on a Windows PC who shoul delete files on a Sun which is in the same network. I try this with the 'remove' command,...
4
by: francescomoi | last post by:
Hi. I'm trying to remove some characters within a string and substitute others. For instance, I want to convert: John's new house, great --->...
7
by: Steve | last post by:
string str ="\"C:\Program Files\Internet Explorer\iexplore.exe\" -nohome" How can I remove charcter to string str = ="C:\Program Files\Internet...
8
by: Jan | last post by:
Hi there, Is there a way to remove spaces from a line of text? For example: vr 12-12-79 city village state name I...
3
by: Mark | last post by:
I need to remove a square character from a text file. How can I locate a square character and remove it? Thanks. Mark
6
by: Daniel Mark | last post by:
Hello all: I have the following snippet: In : fileName = 'Perfect Setup.txt\n' In : fileName = fileName # remove the '\n' character In :...
9
by: Smiley | last post by:
Hi, Can someone tell me how to remove aspostophe (') from user input. I don't want to give any error message. Just want to remove or change it...
26
by: Brad | last post by:
I'm writing a function to remove certain characters from strings. For example, I often get strings with commas... they look like this: "12,384" ...
4
by: MC | last post by:
Is there a string function in .NET that will remove the accent marks from letters? I know that's a slightly vague request... and that I could...
1
by: nyc680 | last post by:
for this c program, i'd like to remove the substring "cc" and character "=" from input string "aaccbbccdd" the code below can only remove "cc" once,...
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.