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
Thank you!
Seems to work now. :)
Eva
___
metacard mailing list
metacard@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/metacard
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
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:
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
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
: 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
-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
: 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
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
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; )
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
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
13 matches
Mail list logo