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