SSMS 17.4 - Find & Replace

• DesNorton

  SSC-Insane

  Points: 24401

  More actions

  January 2, 2018 at 3:09 am

  #325281

  In SSMS 2014, I used [ \t]+$ (using RegEx) to find trailing spaces, and replace them with an empty string.
  In SSMS 17.4, this functionality no longer works.

  Has anybody else seen this behaviour, and possibly a fix for it?

  ---

  How to post data/code on a forum to get the best help.

• drew.allen

  SSC Guru

  Points: 76996

  More actions

  January 2, 2018 at 9:52 am

  #1974097

  They switched to using the Visual Studio regex language.  Using Regular Expressions in Visual Studio,

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA

• DesNorton

  SSC-Insane

  Points: 24401

  More actions

  January 2, 2018 at 12:14 pm

  #1974119

  Thank you Drew.
  I will start testing and changing my list of RegEx expressions that I use.

  ---

  How to post data/code on a forum to get the best help.