Eliminating part of a field

M

Michelle

This is related to a previous question I had. I'm trying to eliminate a
specific part of the records in a table. Here's what a few of the records
look like right now:

PIFull:
1st record: $1936.40 @ 24 $2403.87 @ 24 $2890.62 @ 271
2nd record: $2256.50 @ 24 $2824.17 @ 24 $3419.28 @ 284
3rd record: IO $410.91 @ 24 IO $513.63 @ 24 IO $616.36 @
4th record: $1388.73 @ 24 $1851.08 @ 24 $2355.93 @ 391

Several records have that "IO" stored in the record, but not all of them. Is
there a way to elminate only the "IO"s and keep everything else the way it is?
 
K

kc-mass

Run an update query on the field PiFull

Replace PIFull values with "Replace([PIFull], "IO ","")

Kevin
 
M

Michelle

Wow, that wasn't so hard. Thanks!

kc-mass said:
Run an update query on the field PiFull

Replace PIFull values with "Replace([PIFull], "IO ","")

Kevin


Michelle said:
This is related to a previous question I had. I'm trying to eliminate a
specific part of the records in a table. Here's what a few of the records
look like right now:

PIFull:
1st record: $1936.40 @ 24 $2403.87 @ 24 $2890.62 @ 271
2nd record: $2256.50 @ 24 $2824.17 @ 24 $3419.28 @ 284
3rd record: IO $410.91 @ 24 IO $513.63 @ 24 IO $616.36 @
4th record: $1388.73 @ 24 $1851.08 @ 24 $2355.93 @ 391

Several records have that "IO" stored in the record, but not all of them.
Is
there a way to elminate only the "IO"s and keep everything else the way it
is?
Click to expand...
Click to expand...
 
J

John W. Vinson

This is related to a previous question I had. I'm trying to eliminate a
specific part of the records in a table. Here's what a few of the records
look like right now:

PIFull:
1st record: $1936.40 @ 24 $2403.87 @ 24 $2890.62 @ 271
2nd record: $2256.50 @ 24 $2824.17 @ 24 $3419.28 @ 284
3rd record: IO $410.91 @ 24 IO $513.63 @ 24 IO $616.36 @
4th record: $1388.73 @ 24 $1851.08 @ 24 $2355.93 @ 391

Several records have that "IO" stored in the record, but not all of them. Is
there a way to elminate only the "IO"s and keep everything else the way it is?
Click to expand...

Back up your database (of course!) and run an update query updating the field
to

Replace([fieldname], "IO", "")

This will turn

IO $410.91 @ 24 IO $513.63 @ 24 IO $616.36 @

into

$410.91 @ 24 $513.63 @ 24 $616.36 @

You have my encouragement to smite the person who designed this mess stoutly
about the head and shoulders, that's appalling.
 
Top