Eva 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