substring + charindex

• abdalah.mehdoini

  Ten Centuries

  Points: 1028

  More actions

  January 30, 2020 at 10:20 am

  #3721536

  Good morning all

  I have this text string

  \\A1-SRV-05\REPRISE-sollyazar\Allianz_ged\NOVAXEL\ALLIANZ_1\CAL000242\Volvo Allianz\VAZP00069\documents entrants\Gestion Interne RClient - TR- A TRAITER PAR GESTION PARTENAIRES - DEVIS - VAZP00_21835512.MSG

  and I will recover this value

  VAZP00069

  I tried with substring and charindex but without result

  thanks for your help

   

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 30, 2020 at 10:40 am

  #3721539

  What did you already try?  I would try splitting the string and selecting the element you require.

  John

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  January 30, 2020 at 11:40 am

  #3721550

  Duplicate post. See here

  To the OP: what was wrong with the previous solution?

  • This reply was modified 5 years, 7 months ago by Phil Parkin.

  ---

• Jonathan AC Roberts

  SSCoach

  Points: 18407

  More actions

  January 30, 2020 at 12:08 pm

  #3721556

  Answer moved to a different thread

  • This reply was modified 5 years, 7 months ago by Jonathan AC Roberts. Reason: moved answer to https://www.sqlservercentral.com/forums/topic/substring-chrindex/#post-3721591

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  January 30, 2020 at 12:42 pm

  #3721561

  Posting to the original thread would have helped avoid fragmentation of replies.

  ---