Alpha Video Training
Results 1 to 4 of 4

Thread: extracting

  1. #1
    VAR
    Real Name
    Andy Meer
    Join Date
    Mar 2005
    Location
    Atherstone UK
    Posts
    452

    Default extracting

    Hi All,

    I am trying to extract a characters string from the below

    "TCW-E12345-T00000002med025Cyanotic Breath Holding Attack(s)"
    "TCW-E12345-T00000002med017Autism with Fits / Seizures"
    I want to break into three parts

    1 TCW-E12345-T00000002
    2 med025
    3 Cyanotic Breath Holding Attack(s)

    numbers 1 & 2 I can do with left() and right functions number three is the problem

    as above the string from the left is always 26 characters to the end of parts one and two, but form the right the length can be any length,

    as anybody any ideas how to achieve this

    Andy

  2. #2
    Member
    Real Name
    Steve Andrews
    Join Date
    Jan 2004
    Location
    Mahwah, NJ
    Posts
    644

    Default Re: extracting

    substr(strng,27,99)

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: extracting

    Or

    substr(strng,27)

  4. #4
    VAR
    Real Name
    Andy Meer
    Join Date
    Mar 2005
    Location
    Atherstone UK
    Posts
    452

    Default Re: extracting

    Thanks
    Steve/Stan

Similar Threads

  1. extracting number
    By arkeshtk in forum Web Application Server v7
    Replies: 1
    Last Post: 04-12-2008, 12:38 AM
  2. extracting the Path
    By mmaisterrena in forum Application Server Version 8
    Replies: 2
    Last Post: 03-07-2008, 01:34 PM
  3. Extracting day name
    By foodminer in forum Alpha Five Version 6
    Replies: 6
    Last Post: 01-11-2006, 07:19 AM
  4. Extracting highest value
    By Caroline Baker in forum Alpha Five Version 6
    Replies: 2
    Last Post: 02-26-2005, 01:20 AM

Bookmarks

Posting Permissions

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