Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    49

    Unanswered: add numbers in string

    String=1000;2000;3000;4000

    how can i add this nos?

    i need this
    total = 1000+2000+3000+4000=10000

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Check out REPLACE() and EVAL()
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    whilst you are at it have a look at the split function too

  4. #4
    Join Date
    Dec 2007
    Posts
    49
    I found this one and its so simple.

    Total = Eval(Replace(StringName, ";", "+"))

Posting Permissions

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