Trim and Remove Question
What would be the best way to script this solution?
I have multiple records that I need to break out the "account code". Some records end with a number and others don't. The number or "account code" needs to be removed from the "Name" field and moved to an "AccountCode Field". The "Name Field" gives me information two ways 1. Test_T1234 and 2.Test The script needs to remove the character and numbers after the underscore, remove the underscore and set the Account code field with the "account code" leaving the account name in the name field.
I have been able to place the Account code using right text functions but have not correctly trimmed the underscore and have had some inconsistency.
Thanks for the help.