Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2006
    Posts
    2

    Unanswered: cutting a part a field into 2 fields

    I have a db field called "procedure" - it contains data : 101.5 Procedure Name

    What I need to do is cut the number out and save it in one field and then I need to save the name in another field ... I want to use the first <space> to be the divider - but I am not sure how to do that...

    any help would be great.
    J

  2. #2
    Join Date
    Mar 2006
    Posts
    12
    Left({table.Field},5)

    this will select the first 5 characters in your string. which in this case is 101.5
    only problem here is that if your numbers length changes it will cause issues

  3. #3
    Join Date
    Feb 2006
    Posts
    2

    thanks ... but

    the numbers do change in length - that is why I need to use the space - sorry I should have said that in my pervious post !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •