Re: Re: setting itemdel

[Alain Farmer]

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 
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: Re: setting itemdel

[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 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: Re: 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@lists.runrev.com
> > http://lists.runrev.com/mailman/listinfo/metacard
> -- next part --
> An HTML attachment was scrubbed...
> URL:
>  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: setting itemdel

[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

[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?:
>> 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:


--

___
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

Re: setting itemdel

[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: "Discussions on Metacard" 
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" 

  

  --- On Sat, 5/7/11, Mark Schonewille 

  wrote:

  

    From: Mark Schonewille


Subject: 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 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: setting itemdel

[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; ) 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 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 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 Isotalo]

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" 

--- On *Sat, 5/7/11, Mark Schonewille 
//* wrote:



From: Mark Schonewille 
Subject: 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 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
___
metacard mailing list
metacard@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/metacard

Re: setting itemdel

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

[Michael Kann]

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

From: Mark Schonewille 
Subject: 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 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

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