marg 14154 (7/16/2014)
Thank you so much. You have helped a lot!Just one more thing, there is some cases in which there are some values that should be on the same line as OPT but are the next row like for instance 'CFAN !TKD' e.g. below. Would be able to assist or provide a hint on how I could get those values onto the same row as, merge with those values with OPT?
Thank you.
You just look out for those special 3 characters at the start of the line. (OPT,DN,LOC and STN)
If it is neither of those, the values belong to the previous line.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP