regexp in SMAT 5.8.5

Homepage Clovertech Forums Read Only Archives Cloverleaf Cloverleaf regexp in SMAT 5.8.5

  • Creator
    Topic
  • #53820
    Don Brown
    Participant

    We are on QDX 5.8.5. I have a large SMAT file and am looking for a regexp to pull in only messages that have SD as the State in the PID segment. Does anyone have a way to do this without pulling the State SD from other segments? I am open to other suggestions as well.

    Don Brown

    Sanford Health

    Interface Analyst

    605-328-7377

    Don.Brown@sanfordhealth.org

Viewing 1 reply thread
  • Author
    Replies
    • #79055
      Keith McLeod
      Participant

      Give this a whirl.  I am guessing PID:11.3 where 3 is the 4th component in a zero based index notation.  The r helps confirm that you are in the PID segment as opposed to a random occurence of PID.

      rPID(?:[^|]*|){11}(?:[^^]*^){3}(SD)

    • #79056
      Don Brown
      Participant

      Thanks Keith – Your regexp worked great to find only messages with SD in PID:11.3.

      rPID(?:[^|]*|){11}(?:[^^]*^){3}(SD)

      Don Brown

      Sanford Health

Viewing 1 reply thread
  • The forum ‘Cloverleaf’ is closed to new topics and replies.

Forum Statistics

Registered Users
5,119
Forums
28
Topics
9,293
Replies
34,435
Topic Tags
286
Empty Topic Tags
10