Help to write a regular expression

• Helical Johan

  Ten Centuries

  Points: 1033

  More actions

  November 26, 2010 at 10:37 pm

  #142757

  Hi,

  I need write a regular expression:

  1. Must start in caracter - next to any letter.

  2. Must end in caracter - next to any number.

  For example:

  5D-Canada-Alberta-Calgary-5715-#3#3-9990516-V3-Local-8-0-0

  My output is:

  Canada-Alberta-Calgary

  Thanks.....

• diamondgm

  SSCrazy

  Points: 2824

  More actions

  November 29, 2010 at 12:03 am

  #1256123

  What have you tried so far?

  It is unlikely that you will be assisted here if your question seems like homework and your post doesn't follow the recommended criteria.

• Jeff Moden

  SSC Guru

  Points: 1004187

  More actions

  November 29, 2010 at 6:37 am

  #1256220

  Helical Johan (11/26/2010)

  ---

  Hi,

  I need write a regular expression:

  1. Must start in caracter - next to any letter.

  2. Must end in caracter - next to any number.

  For example:

  5D-Canada-Alberta-Calgary-5715-#3#3-9990516-V3-Local-8-0-0

  My output is:

  Canada-Alberta-Calgary

  Thanks.....

  Will the dashes always be present as you've portrayed?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)