How do I find or trim an inconsistent string of characters in a line item?
I am currently importing data with a concatenation of 3 General Ledger identifiers and a customer code. A sample would look like LE10000.LMF10000.1000000 for the first GL indentifiers. Everything is consistent and All LEs are 7 digits, all LMFs are 8 digites and all account codes are 8 digits. I have customer codes that are inconsistent in the number of characted that range from 4 characters to 12 characters. If my list item is LEXXXXX.LMFXXXXX.XXXXXXXX.Customer Code how do I trim off every character after the period after the accounting code? For reference purposes, LE, LMF, ACCT and Customer are each its own list so we need to parse them out for lookups and reporting once the data is imported.