Can't PARSE This STRING Guidance?

• Brody Kilpatrick

  Right there with Babe

  Points: 757

  More actions

  December 12, 2007 at 4:09 pm

  #184760

  Hey Everyone. I have...lots of problems... But I need some help on the one. I have a several columns, and need to parse the digits out of the column. I have come up with two statements, one grabs each side, but I can't seem to put them together. Any help Would be greatly appriciated.

  Here are couple of Fields:

  What I NEED is:

  519

  547

  559

  1049

  What I have accomplished separately is:

  SELECT SUBSTRING(PK, CHARINDEX('>',REVERSE(PK))-1 , LEN(PK)) FROM audit

  <MSLID=519

  <MSLID=547

  <MSLID=559

  <MSLID=1049

  SELECT SUBSTRING(PK, Charindex('=',PK)+1 , len(PK)) FROM audit

  519>

  547>

  559>

  1049>

  But I can't get both sides in the same query. Suggestions?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  December 12, 2007 at 5:00 pm

  #759646

  Would this work?

  SELECT SUBSTRING(PK, Charindex('=',PK)+1 , (len(PK)-1)) FROM audit

  or you could wrap a replace..

  SELECT replace(SUBSTRING(PK, Charindex('=',PK)+1 , len(PK)),'>','') FROM audit

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  December 13, 2007 at 10:53 pm

  #760082

  SELECT

  LEFT(

  RIGHT(PK,Len(PK) - charindex('=',PK)),

  LEN(RIGHT(PK,Len(PK) - charindex('=',PK)))

  -1)

  ---

  
  My blog: http://jahaines.blogspot.com

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 14, 2007 at 1:53 am

  #760103

  SELECT SUBSTRING(pk, Charindex('=',pk)+1 , len(pk)-Charindex('=',pk)-1) from audit

  Regards,

  Ahmed