I have a document that has string value in one cell separated by 5 periods.
1- I need to extract the TYPE value which sits to the right of District values and the left of the pdf values.
2 - The char length of the Districts will vary as well as the char length of the TYPE values.
3 - The only constants here are that there will always be a PERIOD followed by the pdf text (for a total of 4 characters) at the end - AND there will always be 4 PERIODs preceding the desired TYPE value.
The intent is to extract ONLY the TYPE value WITHOUT the PERIOD and the pdf txt superseding.
Thanks in advance.