Parsing data of variable lengths

**JP Romano** · 09-02-2011, 10:36 AM

Good day,

I'm having a little trouble parsing some data the way I would like, and I think a fresh set of eyes (attached to a brain that functions better than my own) might help.

In the attachment, I have a sample of the data I'm trying to parse. There are three columns repeated 3 times (Date, Price, and Yield). The problem I'm having is related to the variances in lengths of the strings, number of spaces between the text values, and lengths of the strings themselves.

Any help is appreciated. If this isn't clear, or any other information would be helpful, please let me know.

Thanks

**Kenneth Hobson** · 09-02-2011, 10:51 AM

Do you want the 3 sets or just one set with the other two to follow?

Can you say what the cost and yield are for row two so that we can see if the 3/8 goes with cost or yield?

**JP Romano** · 09-02-2011, 10:58 AM

Hi, I already have the code that will compile the columns into 1 set of 3, so I'm good there.

For row two
Dates = 9/2 | 8/12 | 7/22
Prices = 113-09 3/8 | 113-06 1/4 | 111-23 3/4
Yields = .486 | .564 | .975

The yields will generally contain a decimal, but are sometimes greater than 1 (e.g. 1.125) The prices generally,but not always, contain a fraction. Sometimes there's nothing at after the whole numbers, and sometimes there's just a "+"

Hope that clarifies a bit, and thank you for your time!