Simple Format text Question

• ballard

  SSC Rookie

  Points: 40

  More actions

  February 14, 2003 at 8:07 am

  #106001

  I am trying to format a string field using VBScript which contains numbers to include a decimal point:

  currently looks like '4550' I want it to look like '45.50'. I am hoping not to have to convert this field to numeric.

  Thanks!

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  February 14, 2003 at 10:36 am

  #449019

  If all of your data elements in that field will always be four characters you could simply use the LEFT and RIGHT functions and concatenate the results with a '.' in between. If the length or number of characters will vary then you will need to use the LEN function as well.

  LEFT(myfield,2) + '.' + RIGHT(myfield,2)

  - or -

  LEFT(myfield, LEN(myfield) -2) + '.' + RIGHT(myfield,2)

  ~Michael

  Michael Weiss

  
  Michael Weiss