Hello stranger, long time!   :)

Technically you ~can~ use RegEx to figure out numeric levels, but as RegEx is meant for text and not numbers, it gets hairy quick (here's a glimpse if you're brave: http://www.regular-expressions.info/numericranges.html).

A much better solution is using ImportOmatic's API. Given a profile like this small sample:

You could create a Virtual Field to be the Letter Code and create a function like this to determine the value based on Column C (gift amount):

Here's the code in text form, hope this helps!

_

Public Function ComputedColumn_635918705544961467( _

ByVal oField as ImportOM.API.iField, _

ByVal Cancel As ImportOM.API.iCancel) As String

'This function must return a text value

Dim sReturn As String = ""

Select Case True

Case val(ofield.Value)

sReturn = "copper"

Case val(ofield.Value) >= 1000 And val(ofield.Value)

sReturn = "silver"

Case val(ofield.Value) >= 5000

sReturn = "gold"

End select

Return sReturn

End Function