>From the docs : "if delimiter evaluates to more than one character, the first character is used." 1 reuse is not required. 2 fields works on FM delimited data so should be lower(FIELDS(raise(ATTNAME),"YS ",2)) 3 this won't work either way as the delimiter will be "Y" not "COMBO YS "
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: June 28, 2006 15:18 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Question about a dictionary item FIELDS(ATTNAME,REUSE("YS "),2) or is it FIELDS(REUSE("YS"),2,ATTNAME) I forget which format is used in the DICT I desc. I haven't tested this. I believe the REUSE needs to be there... George > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Pamela J Robbins > Sent: Wednesday, June 28, 2006 3:01 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Question about a dictionary item > > > Hi, > > I have a multi-value attribute that's made up of free text remarks. > However, we put a couple of system messages there as well. > I need to > extract the 6 digit number that follows the "COMBO YS " in the line > below, but I'm having trouble setting up the conversion code in the > dictionary. > > Misc Text}Misc Text}COMBO YS 073102}Misc Text > > Could someone give me some suggestions? > > -- > Pamela J Robbins New Bolton Center > Senior Programmer Analyst School of Veterinary Medicine > [EMAIL PROTECTED] University of Pennsylvania > 610-925-6438 > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
