Remove text from field

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi - and thanks for reading this!

I am trying to remove text from a field. Sometimes the field will contain
only numbers (and a decimal point) already, but a lot have a leading space
or a word and a space before the number - eg. Price £65.00. I would like to
be able to just leave 65, or 65.00. I need any numbers after the decimal
point (maximum of two digits) if they are not zeroes.

Thanks for your help.
Andy.


.

Relevant Pages

  • Re: Price Data Formatting
    ... I'm loading into the application price data that has a format I do not know ... Since price data format is all dependent on the market selected (say IBM ... rounded/truncated to 2 digits following the decimal as well. ... Dim sStr As String ...
    (microsoft.public.vb.general.discussion)
  • Re: Who do you call when you die ??
    ... As far as taking advantage NOW to get a good price. ... Andy in Eureka, Texas ...
    (soc.retirement)
  • Re: Column space requirements - VARCHAR2 versus NUMBER
    ... that will contain leading zeroes" mean ... The length including leading zeroes is variable and all digits are ... Leading zeros... ... This is 10 numeric characters in one column in a 300 million row ...
    (comp.databases.oracle.misc)
  • Re: Self-service checkouts. Was: in or on
    ... the cover price is in cents. ... that have the extension, and trade books rarely cost more than $99.99. ... first six digits of the UPC would encode the publisher or distributor, ... three-digit publisher prefixes). ...
    (alt.usage.english)
  • Re: First decade of the 20th century
    ... Mike Barnes: ... does prompt me to ask about leading zeroes in dates. ... than typing a couple of digits. ... Using 5/2 for the second of May was common before computers took ...
    (alt.usage.english)