Parse return text string to display in table format in VBA

[usrefromNJ]

Hello Everybody,
I am working on a project and very new in Excel VBA.
I do send .csv file (with column header and row values)to another server via http POST. I get result back in following format


Begin result

Begin DETAIL
Period = "1 "
ExpectedInterest = 9029892.75482713
Interest = 8877502.86254044
ExpectedPrincipal = 1639835.67534955
End
Begin DETAIL
Period = "2"
ExpectedInterest = 9029892.75482713
Interest = 8877502.86254044
ExpectedPrincipal = 1639835.67534955
End



.......
End

This result is coming as a string to me (it is not line delimited).
I am able to capture the result

How can I parse this output and display in the following table format
on my excel sheet using VBA or anyother technique

period ExpectedInterest Interest ExpectedPrincipal
1 value value value
2 value value value

Please please let me know.

Thanks in advance

 

[GlennUK]

You say that the result is not line delimited, but you are showing us data that is line delimited. What exactly do you want, and what is the data that you want hints for processing for?