remove . and an unusual character.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I download a file that contains text as you see below. I need to remove the
.... The problem is that the "." is not really a "." its "..." as one. So if
you replace or subsitute all "." it will not replace that. You can see what
I mean if you backspace once it will delete all "...". Its as if its one
character. Is there a way to remove this unusual character, like maybe just
keep all letters?

NICE…
NICF…
NICI…
NICJ....
NICK…
NICP…
 
If you always have four characters, then the ellipse, you can simply pull
out the left four characters and use it to update a new field.

=Left([YourFieldNameHere],4)
 
Alex,

I am no expert but how about using the Left function. If you will always
have 4 letters or characters to the left of the 3 dots, why not try:

=Left(field,4)
 
Try
Replace(".",Chr(133),"")

Chr(133) is the ellipsis character (3 dots).
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Unfortunately I will not have 4 characters all the time. It can range from
1-7 characters.

Rick B said:
If you always have four characters, then the ellipse, you can simply pull
out the left four characters and use it to update a new field.

=Left([YourFieldNameHere],4)


--
Rick B



Alex said:
I download a file that contains text as you see below. I need to remove
the
... The problem is that the "." is not really a "." its "..." as one. So
if
you replace or subsitute all "." it will not replace that. You can see
what
I mean if you backspace once it will delete all "...". Its as if its one
character. Is there a way to remove this unusual character, like maybe
just
keep all letters?

NICE.
NICF.
NICI.
NICJ....
NICK.
NICP.
Click to expand...
Click to expand...
 
Unfortunately I will not have 4 characters all the time. It can range from
1-7 characters.
 
Try
Replace(".",Chr(133),"")

Chr(133) is the ellipsis character (3 dots).
Click to expand...

John, wouldn't that be

Replace([fieldname], Chr(133), "")

as the UpdateTo in an Update query?

John W. Vinson [MVP]
 
John W. Vinson said:
Try
Replace(".",Chr(133),"")

Chr(133) is the ellipsis character (3 dots).
Click to expand...

John, wouldn't that be

Replace([fieldname], Chr(133), "")

as the UpdateTo in an Update query?
Click to expand...

I could see myself "shorthanding" that
I want to do a nested replace for both,
then typing out explanation of ellipsis
(after I look up how to spell it correctly),
then forgetting to undo shorthand.
I'm not saying that is what John did,
just what I thought about myself when
I saw that....

Replace(Replace([fieldname],Chr(133),""),".","")
 
Yes, that is correct.

I had tested this in the immediate window and somehow copied and pasted the
wrong expression. Thanks for the backup.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

John W. Vinson said:
Try
Replace(".",Chr(133),"")

Chr(133) is the ellipsis character (3 dots).
Click to expand...

John, wouldn't that be

Replace([fieldname], Chr(133), "")

as the UpdateTo in an Update query?

John W. Vinson [MVP]
Click to expand...
 
Back
Top