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
Thanks for the recommendation.
The 100 last characters was just me troubleshooting why it wasn't working.
The formula you suggested is only taking part of the tax ID and none of the tax number, i.e.:
Tax ID: 00-783-000-000
Tax Number: 547
The result is only giving me 783
Or
Tax ID: 11720-000-000
Tax Number: 5698
The result: 11720
How do I make it print the entire two sets of data? Regardless of the leading or ending 0's?
I should add, the formula field type I have selected is Numeric, but my two fields I am trying to concatenate are text. Does that make a difference?
The 100 last characters was just me troubleshooting why it wasn't working.
The formula you suggested is only taking part of the tax ID and none of the tax number, i.e.:
Tax ID: 00-783-000-000
Tax Number: 547
The result is only giving me 783
Or
Tax ID: 11720-000-000
Tax Number: 5698
The result: 11720
How do I make it print the entire two sets of data? Regardless of the leading or ending 0's?
I should add, the formula field type I have selected is Numeric, but my two fields I am trying to concatenate are text. Does that make a difference?