1 Reply Latest reply on May 22, 2006 7:15 AM by Dan Bracuk

    Split  text into  number and  text

      Hi ,

      My problem is something like this....." 5 feet 6 inch ". This is a single string(varchar). since i cannot calculate value (6*5) here .i need to make it taking from database separate. And later calculate value.Is there any possibility throught which i can do something like that.?

      Thanks in advance.
        • 1. Re: Split  text into  number and  text
          Dan Bracuk Level 5
          I could do it for that particular record, but unless every record has the same structure, it will be tough if not impossible. How is the data getting into the db to start with? If you are accepting free text, you might get values like five ft seven, five and a half ft, etc.

          Is it too late to re-design the db so that you have a numeric field for that measurment?