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?
You should probably use the "eval" or "rex" commands to create a new field with the subvalue you want, then join against that field.