Concatenate two fields in the same table.
I am trying to make a unique number to use in a comparison project. To do this, I need to concatenate two fields that are already in my table. Both fields are Text field types. This is what I have ...
Forum Discussion
Yes, I did figure that out.
My problem now is that I need to remove those "-". Any ideas?
My problem now is that I need to remove those "-". Any ideas?
- I haven't tested this, but you will need to use a combination of
Right, NotRight and Left formulas to pull out the parts.
Then combine back together.
var text Left=Left([Tax ID], "-");
var text Right=Right([Tax ID], "-");
var text Middle=Left(NotRight([Tax ID], "-"), "-");
$Left & $Middle & $Right
Does that logic make sense?
