Text Formatting - Changing " and ' to in and ft

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

Guest

Hi there,

I've done this years ago but cannot remember at all how i did it.

I have text that will have data in it such as (1"X4'X8' White Melamine) and
I need to be able to change two things in this data before I can
append/update it with my sql statements.

I need to:
- Change ' to ft
- Change " to in

I'm sure someone has a nice function for this (I hope) or at least point me
in the right direction.

Thanks
 
Replace(Replace([TextField], "'", " ft "), """", " in ")

or

Replace(Replace([TextField], Chr(39), " ft "), Chr(34), " in ")
 
Well that was simple ... *sigh*

Thanks a ton Douglas, I appreciate it.

Douglas J. Steele said:
Replace(Replace([TextField], "'", " ft "), """", " in ")

or

Replace(Replace([TextField], Chr(39), " ft "), Chr(34), " in ")

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Lythandra said:
Hi there,

I've done this years ago but cannot remember at all how i did it.

I have text that will have data in it such as (1"X4'X8' White Melamine)
and
I need to be able to change two things in this data before I can
append/update it with my sql statements.

I need to:
- Change ' to ft
- Change " to in

I'm sure someone has a nice function for this (I hope) or at least point
me
in the right direction.

Thanks
Click to expand...
Click to expand...
 
Back
Top