If I have data that looks like this
How could I create an eval statement that says
if field1=abc or if field1=field1+456 then field1=field1?
Meaning, combine "abc" and "abc456", and combine "xyz" and "xyz456" together.
Solved it, used the like function
View solution in original post
A bit more info as I think I gave a poor example
abc can be 3 positions or it could be abcdef (more than 3 positions), however, 456 is always consistent