Re: Re: setting itemdel

2011-08-05 Thread Alain Farmer
_ From: FlexibleLearning To: metacard@lists.runrev.com Sent: Sunday, May 8, 2011 1:14:19 PM Subject: RE: Re: setting itemdel A regex would certainly be better. As it requires a degree of coding proficiency that was not evident when the question was initially raised, I provided a solution

RE: Re: setting itemdel

2011-05-08 Thread FlexibleLearning
A regex would certainly be better. As it requires a degree of coding proficiency that was not evident when the question was initially raised, I provided a solution to suit. Would you like to give us your matchtext solution rather than a copied generic? Hugh Senior FLCo Alain Farmer wrote: Best

RE: Re: setting itemdel

2011-05-08 Thread 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 TA

Re: setting itemdel

2011-05-08 Thread Eva Isotalo
Thank you! Seems to work now. :) Eva ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard

RE: Re: setting itemdel

2011-05-07 Thread 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

Re: setting itemdel

2011-05-07 Thread Michael Kann
Eva, I meant to type "quick", but "quirky" would probably best describe my programming suggestions. Don't hesitate to ask if you need some fresh eyes to help out. --- On Sat, 5/7/11, Eva Isotalo wrote: From: Eva Isotalo Subject: Re: setting itemdel To: "

Re: setting itemdel

2011-05-07 Thread Eva Isotalo
Solved it. Not pretty but works. :) Eva On 2011-05-07 18:38, Eva Isotalo wrote: 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; ) EO

Re: setting itemdel

2011-05-07 Thread Eva Isotalo
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

Re: setting itemdel

2011-05-07 Thread Eva Isotalo
might want to also check out the LiveCode list also. It is the more recent version of the metacard list. Here it is: How to use LiveCode" --- On *Sat, 5/7/11, Mark Schonewille //* wrote: From: Mark Schonewille Subject: Re: setting itemdel To: "Discussions on Metacard

Re: setting itemdel

2011-05-07 Thread Michael Kann
Eva, I just realized you posted on the metacard list. You might want to also check out the LiveCode list also. It is the more recent version of the metacard list. Here it is: How to use LiveCode" --- On Sat, 5/7/11, Mark Schonewille wrote: From: Mark Schonewille Subject: Re: se

Re: setting itemdel

2011-05-07 Thread Michael Kann
t: Re: setting itemdel To: "Discussions on Metacard" Date: Saturday, May 7, 2011, 9:06 AM 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 myDa

Re: setting itemdel

2011-05-07 Thread Mark Schonewille
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

setting itemdel

2011-05-07 Thread Eva Isotalo
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