UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Search And Replace "*" Character, Office 2010    
 
   
haresfur
post May 14 2019, 09:02 PM
Post#1



Posts: 300
Joined: 4-April 12
From: Bendigo, Australia


I was given a spreadsheet with the character "*" in several numeric cells that I needed to replace before I joined the sheet to Access.

I tried searching for *, "*", /*, '* which didn't work. I ended up editing by hand but for my edification, can anyone tell me how to search and replace the literal character, not treating it as a wildcard?

--------------------
-- Evan
Go to the top of the page
 
GroverParkGeorge
post May 14 2019, 09:47 PM
Post#2


UA Admin
Posts: 35,175
Joined: 20-June 02
From: Newcastle, WA


You could try using the ASCII character, i.e. Chr(42)

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
haresfur
post May 15 2019, 12:02 AM
Post#3



Posts: 300
Joined: 4-April 12
From: Bendigo, Australia


Entering the ascii code didn't work but I did find this help:

Tip: You can find asterisks, question marks, and tilde characters (~) in worksheet data by preceding them with a tilde character in the Find what box. For example, to find data that contain "?", you would type ~? as your search criteria.

Not exactly obvious.

--------------------
-- Evan
Go to the top of the page
 
Minty
post May 15 2019, 03:50 AM
Post#4



Posts: 310
Joined: 5-July 16
From: UK - Wiltshire


Another way, you can surround the character with [] so to find any customer name with a * in it you would use

CODE
SELECT customers.CUSTOMER
FROM customers
WHERE customers.CUSTOMER) Like "*[*]*"


Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th June 2019 - 01:10 PM