I would normally work with the dynamic array, and convert when done Aside from CONVERT @VM TO "," IN X.STRING
Also... X.STRING = '"' : CHANGE(X.STRING,@VM,'","') : '"' If you need quoted comma delimited - this will NOT however, change embedded "'s which will corrupt your data -----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 2:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' 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 <ggal...@wyanokegroup.com> To: U2 Users List <u2-users@listserver.u2ug.org> 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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Monday, October 31, 2011 1:43 PM o: u2-users@listserver.u2ug.org 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 <coe...@american.edu> o: u2-users <u2-users@listserver.u2ug.org> 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 -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________ 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
