Topic
  • No replies
SystemAdmin
SystemAdmin
533 Posts

Pinned topic Help with Patterns

‏2012-03-20T04:18:30Z |
I created a custom rule set based out of USNAME ruleset for name standardization. Input to the ruleset must be in this format - ZQ,FirstName,ZQ,MiddleInitial,ZQ,LastName

When I pass repeated words to FirstName column, I see that the spaces are not preserved.
For example, if I pass input string - "ZQ,AB BB CR,ZQ,J,ZQ,LARRY" , the ruleset gives "AB BB CR" in the FirstName output column. But when I pass a input string "ZQ,AB AB CR,ZQ,J,ZQ,LARRY" I see that the output is "AB ABCR" with the space between AB and CR removed.

Can someone help me to identify what I am missing in the patterns. Here are the patterns in the PAT file.
!Z | !Z | + | !Z | Z
COPY [1] Temp
CONCAT " " Temp
CONCAT [2] Temp
CONCAT " " Temp
CONCAT [3] Temp
CONCAT " " Temp
CONCAT [4] Temp
COPY Temp {FirstName}
RETYPE [1] 0
RETYPE [2] 0
RETYPE [3] 0
RETYPE [4] 0
RETYPE [5] 0
RETURN

!Z | !Z | F | !Z | Z
COPY [1] Temp
CONCAT " " Temp
CONCAT [2] Temp
CONCAT " " Temp
CONCAT [3] Temp
CONCAT " " Temp
CONCAT [4] Temp
COPY Temp {FirstName}
RETYPE [1] 0
RETYPE [2] 0
RETYPE [3] 0
RETYPE [4] 0
RETYPE [5] 0
RETURN

& | !Z | !Z | Z
COPY [1] Temp
CONCAT " " Temp
CONCAT [2] Temp
CONCAT " " Temp
CONCAT [3] Temp
COPY Temp {FirstName}
RETYPE [1] 0
RETYPE [2] 0
RETYPE [3] 0
RETYPE [4] 0
RETURN

& | !Z | Z
COPY [1] Temp
CONCAT " " Temp
CONCAT [2] Temp
COPY Temp {FirstName}
RETYPE [1] 0
RETYPE [2] 0
RETYPE [3] 0
RETURN

& | Z
COPY [1] {FirstName}
RETYPE [1] 0
RETYPE [2] 0
RETURN