replacing prices on a text

[hakkatil]

I need to replace prices with spaces or delete them that comes from database. Prices can be 2, 3 or 4 digits. For example the line is "this products is $45.99". How can I replace $45.99 with spaces or delete it. The amount can be $123.33 or $.99 or $1.99. Is there an easy way to do that?

 

[bastienk]

I am assuming that you are referencing the db value when writing the statement. Is there some criteria for a time when the prices are not to be displayed or is it for everyone?


Bastien

Cat, the other other white meat

 

[hakkatil]

it is for everyone. This information comes from a shopping cart database. There are many records. Some of these records contains prices. When these reports display on page, I don't want to display prices that in a text.

Say we have 3 records to display on a page.

This product is $49.99.
This products is $19.99 and addition for a color $5.99.
this product is $145.99.

What I want is when those records above diplayed, delete the prices or replace with spaces.

This product is ***.**.
This products is ***.** and addition for a color **.**.
this product is ****.**

 

[bastienk]

You store the price attribute separately or is it a text element containing the full string?



Bastien

Cat, the other other white meat

 

[hakkatil]

it is a text element containing the full string.

 

[bastienk]

use regex to replace the values...

ex...google the net to find more examples

Dim regEx, str1               ' Create variables.
  str1 = "The quick brown fox jumped over the lazy dog."
  Set regEx = New RegExp            ' Create regular expression.
  regEx.Pattern = patrn            ' Set pattern.
  regEx.IgnoreCase = True            ' Make case insensitive.
  ReplaceTest = regEx.Replace(str1, replStr)   ' Make replacement

Bastien

Cat, the other other white meat

 

[hakkatil]

Can I use this with different prices? Some prices have 3, some have 4, some have 5 digits.

 

[bastienk]

yes

Regex looks for patterns


Bastien

Cat, the other other white meat

 

[hakkatil]

thank you very much.