locked
Tagged text marker \1 doesn't work in SSMS v17.2 RRS feed

  • Question

  • tegged text marker \1 doesn't work in SSMS v17.2. 

    Instead to replace tagged text group it replaces itself literary.

    For example:

    Searched text: MSH|^~\&|BIS||MBO||20180417093008.7646+0200||OMG^O19^OMG_O19|1d1187d5-7681-4acd-b|P^T|2.5||||||8859/2 PID|||893325^^^^PI~""^^^^PN~101778138^^^^HC~03446454967^^^^OIB||SANDRO^GALOVIĆ||19460830000000.0000+0200|M|||Trg 1. Istarske brigade 14^^ĐAKOVO^^31400^^P~""^^^^^^H~031811681-TOSENBERGER^^^^^^M||^^^^^^^^^^^031816576|||U||||||||||191 PV1||O|||||0162825^MIŠETIĆ DOLIĆ^ZRINKA ORC|NW|3795323|||||^^^^^S||20180417092400.0000+0200|1||1769^MIŠETIĆ DOLIĆ^ZRINKA^^^^^^^^^^^^^&0162825&&&MIŠETIĆ DOLIĆ ZRINKA (0162825)|4^2010-1^^^^^^^Hitna internistička||||||0^"" TQ1||1|||||||S OBR|1|3795323||7011^Obrisak tekućine iz srednjeg uha MBO-LIS|||||||||||||||||||||||1 DG1|1||J12.1^Pneumonija uzrokovana respiracijskim sincicijalnim virusom^I10|||A ORC|NW|3795324|||||||20180417092400.0000+0200|1||1769^MIŠETIĆ DOLIĆ^ZRINKA^^^^^^^^^^^^^&0162825&&&MIŠETIĆ DOLIĆ ZRINKA (0162825)|4^2010-1^^^^^^^Hitna internistička||||||0^"" TQ1||1|||||||S OBR|1|3795324||7014^Obrisak nosa nadzor MBO-LIS|||||||||||||||||||||||1

    Search: {ERR|PID|OBX|PV1|SPM|OBR|ORC|DG1|TQ1|MSA|NTE|QRF|QRD|ARQ|EVN|IN1|SCH}\|

    Replace: \n\1|

    Result:

    MSH|^~\&|BIS||MBO||20180417093008.7646+0200||OMG^O19^OMG_O19|1d1187d5-7681-4acd-b|P^T|2.5||||||8859/2 

    \1||||893325^^^^PI~""^^^^PN~101778138^^^^HC~03446454967^^^^OIB||SANDRO^GALOVIĆ||19460830000000.0000+0200|M|||Trg 1. Istarske brigade 14^^ĐAKOVO^^31400^^P~""^^^^^^H~031811681-TOSENBERGER^^^^^^M||^^^^^^^^^^^031816576|||U||||||||||191 

    \1|||O|||||0162825^MIŠETIĆ DOLIĆ^ZRINKA 

    \1||NW|3795323|||||^^^^^S||20180417092400.0000+0200|1||1769^MIŠETIĆ DOLIĆ^ZRINKA^^^^^^^^^^^^^&0162825&&&MIŠETIĆ DOLIĆ ZRINKA (0162825)|4^2010-1^^^^^^^Hitna i

    \1|rnistička||||||0^"" 

    \1|||1|||||||S 

    \1||1|3795323||7011^

    \1|isak tekućine iz srednjeg uha MBO-LIS|||||||||||||||||||||||1 

    \1||1||J12.1^Pneumonija uzrokovana respiracijskim sincicijalnim virusom^I10|||A 

    \1||NW|3795324|||||||20180417092400.0000+0200|1||1769^MIŠETIĆ DOLIĆ^ZRINKA^^^^^^^^^^^^^&0162825&&&MIŠETIĆ DOLIĆ ZRINKA (0162825)|4^2010-1^^^^^^^Hitna i

    \1|rnistička||||||0^"" 

    \1|||1|||||||S 

    \1||1|3795324||7014^

    \1|isak nosa nadzor MBO-LIS|||||||||||||||||||||||1

    Which is wrong. "Regular expressions" option is selected.

    Also tried $1 with the same result.

    Tuesday, April 17, 2018 8:22 AM

All replies

  • $1 seems to work for me in SSMS 17.6. (And it should work in 17.2 as well, as this functionality that comes with the Visual Studio Isolated Shell.)

    Tuesday, April 17, 2018 9:51 PM