Best solution for this would be a GREP pattern. :) Example: .*([0-9]+).*
PS: use metacard's replaceText syntax. Al > replace " (Size: 100ml; )" with " 100" in fld "Product" > > > But you have different 'size' values. This removes the > non-numeric > characters... > > set the itemDel to TAB > repeat with n=1 to num of lines of fld "Product" > replace "(Size: " with "" in item 2 of line n > of fld "Product" > replace "ml;)" with "" in item 2 of line n of > fld "Product" > replace "g;)" with "" in item 2 of line n of > fld "Product" > end repeat > > > Hugh Senior > FLCo > > > > Ok, a continuation. On lines like the following I'd like to > be able to > catch and delete the '(Size: 100ml;)' but keep the '100'. > How would I go > about doing this? > > 1 Benzoin (Mobile) Siam (Size: > 100ml; ) EO16-100 > 7.55 > Eva > > > On 2011-05-07 16:06, Mark Schonewille wrote: > > Hi Eva, > > > > I'm not sure what you are having problems with, but if > you want to get the > items of a line, you need to set the itemdel to tab. > > > > set the itemDel to tab > > put item 2 of line 3 of myData into fld "Product" > > > > -- > > Best regards, > > > > Mark Schonewille > > > > Economy-x-Talk Consulting and Software Engineering > > Homepage: http://economy-x-talk.com > > Twitter: http://twitter.com/xtalkprogrammer > > KvK: 50277553 > > > > New: Download the Installer Maker Plugin 1.6 for > LiveCode here > http://qery.us/ce > > > > On 7 mei 2011, at 16:02, Eva Isotalo wrote: > > > >> MC 2.4.3 > >> > >> How do I "catch" the different parts of a file > that has columns like > this?: > >> 1 Rose Floral Wax: (Size: 25g; > ) FW07-25 ?3.65 > ?3.65 > >> 1 Jasmine Grandaflorum Floral > Wax (Size: 25g; ) FW03-25 > ?2.95 ?2.95 > >> 1 Mimosa Floral Wax (Size: 25g; > ) FW05-25 ?2.95 > ?2.95 > >> > >> > >> I have no problems reading it but I'm trying to > make an app that will > read invoices in to a inventory program where each product > will get it's own > card. > >> > >> Eva > > > > > > _______________________________________________ > > metacard mailing list > > metacard@lists.runrev.com > > http://lists.runrev.com/mailman/listinfo/metacard > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > <http://lists.runrev.com/pipermail/metacard/attachments/20110507/e7a7acc5/at > tachment-0001.html> > > ------------------------------ > > _______________________________________________ > metacard mailing list > metacard@lists.runrev.com > http://lists.runrev.com/mailman/listinfo/metacard > > > End of metacard Digest, Vol 83, Issue 2 > *************************************** > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 10.0.1325 / Virus Database: 1500/3622 - Release > Date: 05/07/11 > > > _______________________________________________ > metacard mailing list > metacard@lists.runrev.com > http://lists.runrev.com/mailman/listinfo/metacard > _______________________________________________ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard