?
Solved

Replace Blank Space with %20

Posted on 2006-07-06
4
Medium Priority
?
537 Views
Last Modified: 2013-12-24
How can I make sure that if I persone types in a name like Big Johnny, that it reads the name when retrieved as Big%20Johnny

0
Comment
Question by:jeffmace
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 25

Expert Comment

by:James Rodgers
ID: 17050344
try using urlencode

urlencode(string)
0
 
LVL 25

Accepted Solution

by:
James Rodgers earned 1000 total points
ID: 17050358
you can also try rereplace

#rereplace(string," ","%20","all")#
0
 

Author Comment

by:jeffmace
ID: 17050368
Thank you for both tips.. Great job!!!
0
 
LVL 25

Expert Comment

by:James Rodgers
ID: 17050399
glad i could help

thanks for the points

0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 22 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question