setting itemdel

[FlexibleLearning]

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 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