Join on indexed value with a wildcard

[Cuyose]

I am trying to join on indexed data where I want to have something like 123 join with 123 and also 123-14XXx

Where 123 is variable. I can't seem to figure out what to use here, basically the logic is if there is a dash, strip it and everything after it off before attempting the join.

Any ideas?

[gkanapathy]

You should probably use the "eval" or "rex" commands to create a new field with the subvalue you want, then join against that field.