Posted: Thu May 20, 2010 7:34 am
This is the first mention that a column may not be present, and adds hugely to the complexity of the solution.
For each field you will first need to determine existence in the string, then find the delimiters (more specifically the character positions thereof) to the left and right of this position in the string, and extract the intervening characters.
That's a specification in English; try to implement this as an expression and let us know how you fared.
For each field you will first need to determine existence in the string, then find the delimiters (more specifically the character positions thereof) to the left and right of this position in the string, and extract the intervening characters.
That's a specification in English; try to implement this as an expression and let us know how you fared.