Or you can use :-
MATCHFIELD(F1,\0X'PRN="'0X'"'0X\,3) To directly extract the value. This works in Universe but not sure if Unidata supports the third (\) quote symbol. If not then you can use :- MATCHFIELD(F1,"0X'PRN=":'"':"'0X'":'"':"'0X",3) Which is not quite as readable. Cheers, Andy ________________________________ From: Bob Woodward <bob_woodw...@k2sports.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Thursday, 19 May 2011, 20:30 Subject: Re: [U2] Multi char delimiter in DICT item WINNER!!!! We can even remove the fourth statement since the third statement puts the first quoted value at the front of @3 so... F1 ; INDEX(F1,"PRN=",1) ; @1[@2,LEN(@1)] ; FIELD(@3,'"',2) Will work perfectly! Thank you very much! -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, May 19, 2011 12:22 PM To: U2 Users List Subject: Re: [U2] Multi char delimiter in DICT item what about.... F1 ; INDEX(F1,"PRN=",1) ; @1[@2,LEN(@1)] ; FIELD(@3,"=",2) ; FIELD(@4,'"',2) George > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Bob Woodward > Sent: Thursday, May 19, 2011 2:59 PM > To: U2 Users List > Subject: Re: [U2] Multi char delimiter in DICT item > > That won't get me any closer. Reason is that we have differing numbers > of options possible. I really need to somehow identify where "PRN" (or > /PRN or PRN= or ...) is. Once I have that, I can use FIELD on the > double quotes to get what I want. > > Double slashes won't work, either, as FIELD still just takes the first > slash character and uses it. > > Here's a sample of the data line I'm working with but, again, the > number > of options and option commands can change. Only "/PRN=" is going to be > guaranteed to be unique to that data position. (The sample may wrap but > it's a single line.) > > 001: %BTW% /RUN /f="C:\BarTender\Template\Comply-FTL.btw" > /d="\\ganymede\DCDOWN\5214411.dat" /p /PRN="BoxLabel3" /x > > > Thanks, > BobW > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > Sent: Thursday, May 19, 2011 11:46 AM > To: U2 Users List > Subject: Re: [U2] Multi char delimiter in DICT item > > hmmm. looks like I need glasses...didn't see you already answered it. > > Is there an = sign in any of the label data? > > FIELD(@1,"=",2) ; FIELD(@2,'"'2) > > Don't look for PRN= , just = > > George > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of George Gallen > > Sent: Thursday, May 19, 2011 2:30 PM > > To: U2 Users List > > Subject: Re: [U2] Multi char delimiter in DICT item > > > > Does CHANGE work with Unidata? > > > > CHANGE(F1,"PRN",CHAR(251)) ; FIELD(@1,CHAR(251),2) ; FIELD(@2,'"',2) > > > > George > > > > > -----Original Message----- > > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > > boun...@listserver.u2ug.org] On Behalf Of Bob Woodward > > > Sent: Thursday, May 19, 2011 2:11 PM > > > To: U2 Users List > > > Subject: [U2] Multi char delimiter in DICT item > > > > > > Hi folks, > > > > > > I'm in Unidata 6.1 and I'm trying to find a way to use a multi > > > character > > > value as a delimiter for a parsing function in an I-desc dict item. > > > I'm > > > working with Bartender label data records and I'm trying to parse > the > > > first line on the "/PRN=" value, without the quote marks. FIELD > only > > > lets me use a single character. > > > > > > What I have so far in the DICT item is: > > > 001: I > > > 002: F1;FIELD(@1,'PRN=',2);FIELD(@2,'"',2) > > > 003: > > > 004: PRN > > > 005: 15L > > > 006: S > > > > > > This works great until a capital P is in the label name before the > > PRN. > > > Field is taking the first character and ignoring the RN=. I do NOT > > > want > > > to make a subroutine if I can avoid it. I've tried using CHANGE to > > > swap > > > out PRN= with a single character but apparently that's not an > allowed > > > command in the DICT items. > > > > > > Thanks for any help you can offer. > > > > > > BobW > > > > > > _______________________________________________ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
