How about? LOCATE X.CODE IN CHANGE(X.STRING,",",CHAR(254)) SETTING POS ELSE X.STRING=X.STRING:",":X.CODE
Or LOCATE X.CODE IN CHANGE(X.STRING,",",CHAR(254))<1> SETTING POS ELSE X.STRING=X.STRING:",":X.CODE Depending on which UV Flavor your running -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 31, 2011 1:43 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' Does Matches recognize comma as a delimiter? I don't think it does. IF NOT(X.STRING) MATCH X.CODE THEN X.STRING<1,-1> = X.CODE -----Original Message----- From: Greg Coelho <coe...@american.edu> To: u2-users <u2-users@listserver.u2ug.org> Sent: Mon, Oct 31, 2011 10:37 am Subject: Re: [U2] Using 'MATCH' Hey Guys, I am concatenating an alpha code into a string providing that the code oes not already exist (in the string). If my existing string = X.STRING nd my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN ND ELSE X.STRING = X.STRING:',':X.CODE ND Thanks! Greg ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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