Hi Mike, How are you? I left couple of e-mails earlier but no luck. Please pass me your home number and the mobile and I'll call you one of these days. Man, it has been a loong long time and like to talk to you soon. Hope every thing is fine at your end. Cheers Mo Home: +94112527461 Cell: +94777749247
--- On Fri, 3/13/09, Michael Rajkowski <[email protected]> wrote: From: Michael Rajkowski <[email protected]> Subject: Re: [U2] - UniBasic String Search To: [email protected] Cc: [email protected], [email protected] Date: Friday, March 13, 2009, 10:07 AM If you are looking for something quick then create a dict item with the match criteria you want to search for, the following example is based of the UniData demo account file TAPES Add an item: AE DICT TAPES MTYPE Top of "MTYPE" in "DICT TAPES", 6 lines, 33 characters. *--: p 001: I 002: "'C'":@VM:"'R'" 003: 004: MY TYPES 005: 10L 006: S Bottom. Then use the MATCH keyword on you query statement. LIST TAPES WHEN CATEGORIES MATCH MTYPE CATEGORIES 11:06:14 Mar 13 2009 1 TAPES..... Type of Video V4951 C V1231 C V1249 R V110 C V9431 C B914 R B2297 R V8181 C 8 records listed Michael Rajkowski SWG Client Support - Information Management Software Software Engineer ? IBM U2 Client Support Team 1-800-729-3553 [email protected] "Brutzman, Bill" <[email protected]> Sent by: [email protected] 03/13/2009 08:39 AM Please respond to [email protected] To <[email protected]> cc Subject [U2] - UniBasic String Search I need to examine fields for perhaps one thousand part.numbers looking for tech specs that contain character strings like "MIL" "Spec" "SPEC" "-14" etc While I can do this with commands like... execute 'SELECT IM WITH OP.SPEC LIKE "...-14..." ', this technique is awkward since I have a few dozen strings to look for... I have the IBM tech manual describing the MATCH operator and the MATCHFIELD function. Is there a handy UniBasic method to handle this or should I write a little program to do this myself? Fixes would be appreciated. --Bill ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif] [demime 1.01d removed an attachment of type image/gif] [demime 1.01d removed an attachment of type image/jpeg] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
