If there is a need to extrude the result comma-delimited then IF NOT(X.STRING) MATCH X.CODE THEN X.STRING<1,-1> = X.CODE CONVERT "," TO @VM IN X.STRING
-----Original Message----- From: George Gallen <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Oct 31, 2011 11:47 am Subject: Re: [U2] Using 'MATCH' How about? LOCATE X.CODE IN CHANGE(X.STRING,",",CHAR(254)) SETTING POS ELSE .STRING=X.STRING:",":X.CODE Or LOCATE X.CODE IN CHANGE(X.STRING,",",CHAR(254))<1> SETTING POS ELSE .STRING=X.STRING:",":X.CODE epending on which UV Flavor your running -----Original Message----- rom: [email protected] [mailto:[email protected]] n Behalf Of Wjhonson ent: Monday, October 31, 2011 1:43 PM o: [email protected] ubject: Re: [U2] Using 'MATCH' oes 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----- rom: Greg Coelho <[email protected]> o: u2-users <[email protected]> ent: Mon, Oct 31, 2011 10:37 am ubject: Re: [U2] Using 'MATCH' ey Guys, am concatenating an alpha code into a string providing that the code es not already exist (in the string). If my existing string = X.STRING d my code = X.CODE should the following work? F X.STRING MATCH X.CODE THEN D ELSE X.STRING = X.STRING:',':X.CODE D hanks! reg _____________________________________________ -Users mailing list [email protected] tp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
