Match and If formula

[MarkP]

You could just strip the numbers - check Marek’s variable part way down this topic:

120×120 10.4 KB

In WebI I need to find a way to extract the numeric portion of a string. In DeskI, the tonumber(string) function works fine, but it doesn’t in WebI. For example: String…Numeric 1…1 2…2 3A…3 3B…3 4…4 4A…4 4B…4 4C…4 … 10A…10 … 100…100 100A…100 100Aa…100 Any ideas? Looks like in WebI, the numeric portion needs to be extracted before tonumber() can convert it. I’m not sure how to get rid of the random characters at the end. Thanks! JonTarz (BOB member since 2006-01-09)