Re: Re: setting itemdel
function extractNumberFromString pString put .*([0-9]+).* into myRegex local x,y if matchChunk(pString, myRegex, x, y) then return char x to y of pString else return pString -- unmodified string to leave field as-is. end extractNumberFromString on example -- field contains: (Size: 100ml; ) -- it should contain just the value: 100 put extractNumberFromString(fld Product) into fld Product -- e.g. replaces (Size: 100ml; ) with 100 -- if it fails then it leaves string intact. end example From: FlexibleLearning ad...@flexiblelearning.com 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 to suit. Would you like to give us your matchtext solution rather than a copied generic? Hugh Senior FLCo Alain Farmer wrote: 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 ___ 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
Re: setting itemdel
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
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
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 to suit. Would you like to give us your matchtext solution rather than a copied generic? Hugh Senior FLCo Alain Farmer wrote: 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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
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
Re: setting itemdel
Eva and Mark, Here's a quirk way to group the products: set the itemDel to tab put fld 1 into v --- list of invoices sort lines of v by item 2 of each put v into fld 2 -- products will be grouped together --- On Sat, 5/7/11, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: From: Mark Schonewille m.schonewi...@economy-x-talk.com Subject: Re: setting itemdel To: Discussions on Metacard metacard@lists.runrev.com 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 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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
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 use-livec...@lists.runrev.com --- On Sat, 5/7/11, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: From: Mark Schonewille m.schonewi...@economy-x-talk.com Subject: Re: setting itemdel To: Discussions on Metacard metacard@lists.runrev.com 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 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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
Thank you guys! I had placed the itemdel 'tab' in quotes, that's why it didn't work. Sigh... Works fine now. And thanks for the great quirky suggestion. :) Eva On 2011-05-07 16:44, Michael Kann wrote: 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 use-livec...@lists.runrev.com --- On *Sat, 5/7/11, Mark Schonewille /m.schonewi...@economy-x-talk.com/* wrote: From: Mark Schonewille m.schonewi...@economy-x-talk.com Subject: Re: setting itemdel To: Discussions on Metacard metacard@lists.runrev.com 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 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 /mc/compose?to=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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
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; ) 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 herehttp://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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard
Re: setting itemdel
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 eva.isot...@gmail.com wrote: From: Eva Isotalo eva.isot...@gmail.com Subject: Re: setting itemdel To: Discussions on Metacard metacard@lists.runrev.com Date: Saturday, May 7, 2011, 10:01 AM Thank you guys! I had placed the itemdel 'tab' in quotes, that's why it didn't work. Sigh... Works fine now. And thanks for the great quirky suggestion. :) Eva On 2011-05-07 16:44, Michael Kann wrote: 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 use-livec...@lists.runrev.com --- On Sat, 5/7/11, Mark Schonewille m.schonewi...@economy-x-talk.com wrote: From: Mark Schonewille m.schonewi...@economy-x-talk.com Subject: Re: setting itemdel To: Discussions on Metacard metacard@lists.runrev.com 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 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 ___ metacard mailing list metacard@lists.runrev.com http://lists.runrev.com/mailman/listinfo/metacard -Inline Attachment Follows- ___ 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
RE: Re: setting itemdel
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?: 1Rose Floral Wax: (Size: 25g; ) FW07-25 ?3.65 ?3.65 1Jasmine Grandaflorum Floral Wax (Size: 25g; ) FW03-25 ?2.95 ?2.95 1Mimosa 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