markster
Well-known Member
- Joined
- May 23, 2002
- Messages
- 579
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello
I've been working on automating a report to save me lots of time but different systems display the transaction number in a different way. The majority of the data from different systems has the transaction number in the following format so I want to stick with this format TH_G329_S10_CL6_TF60
There's one system where it's quite different and I need it to to convert the transaction number to be in he format shown above. The screen shot below shows what I need:
Any help would be much appreciated. Thanks Mark
I've been working on automating a report to save me lots of time but different systems display the transaction number in a different way. The majority of the data from different systems has the transaction number in the following format so I want to stick with this format TH_G329_S10_CL6_TF60
TH_G320_S10_J10_CL6_TF60 |
Any help would be much appreciated. Thanks Mark