I know this should be easy but I am not seeing a clear answer to this.
I have a data file with 15 fields of data. Field 15 can contain data that is 0000000000_XX or XXQQQQQQ.
What I want to do is check the field for the underscore and return the last two characters if they exist otherwise I want the first two characters. The characters in question are a divisional code I will use later to group, sort and generate totals in a report.
Thank you in advance for your assistance and make it a great day.
SteveR77
I.T. where a world of choas and confusion comes down to nothing but 1s and 0s.
I have a data file with 15 fields of data. Field 15 can contain data that is 0000000000_XX or XXQQQQQQ.
What I want to do is check the field for the underscore and return the last two characters if they exist otherwise I want the first two characters. The characters in question are a divisional code I will use later to group, sort and generate totals in a report.
Thank you in advance for your assistance and make it a great day.
SteveR77
I.T. where a world of choas and confusion comes down to nothing but 1s and 0s.