I tried the same thing as you have suggested. However, the problem I am having is that some times there will be 4 “*” and other times “3 “*” between the first name and “MI”.
Eg. NM1*QC*1*ARAGON*ELOISA****MI*YIJ804040413
NM1*QC*1*ARAGON*ELOISA***MI*YIJ804040413
So, I am guessing I would need to split with the text “MI”, but not sure how to do that?
Mypersonal opinion is chasing X12 with Tcl vs Xlate and variant is a waste of effort.
In either case, you need to understand the entirety of the use of the X12 segment at the various levels and loops. So vendor documentation iis essential.
It is also possible this particular provider of the X12 message is not following the standard although the X12 standard is quite vigorously enforced unlike HL/7.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
Thank you all for your responses, I really appreciated the timely solutions also.
Keith, I didn’t see the other option you had and that was the regex. That certainly did the trick as well as Charlie’s solution. I will treasure them and have added them to my documentation!
Thanks again!
Author
Replies
Viewing 4 reply threads
The forum ‘Cloverleaf’ is closed to new topics and replies.