setting itemdel

[Alain Farmer]

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 at 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 at 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 at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard
>