How to get only the last string before comma

• niladri.primalink

  SSCommitted

  Points: 1751

  More actions

  March 14, 2016 at 6:12 am

  #150484

  Hi All,

  I have a string like below

  DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt

  I want to get the last one that is Paymt. Actually the upper section is generated from a variable. there may be other values we can get but I want only the last one beofre comma (,).

  From the string DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt I want only "Paymt"

  Can you please help me?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 14, 2016 at 6:17 am

  #1864879

  You want the string after the last comma?

  The one before the last comma would be LoanDate

  DECLARE @str VARCHAR(250) = 'DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt'

  SELECT REVERSE(LEFT(REVERSE(@str), CHARINDEX(',', REVERSE(@str))-1))

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• niladri.primalink

  SSCommitted

  Points: 1751

  More actions

  March 14, 2016 at 6:26 am

  #1864882

  Hi GilaMonster,

  You are terrific. It works like a charm!!

  Thanks you so much

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  March 14, 2016 at 7:09 am

  #1864897

  How about reducing some steps?

  DECLARE @str VARCHAR(250) = 'DWDate,Email,UserID,ID,LoanNum,PersonEmail,LoanDate,Paymt'

  SELECT RIGHT(@str, CHARINDEX(',', REVERSE(@str))-1)

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2