>>>>Just think of a big bunch of text with "MSH" and "EVN" imbedded at the beginning of lines. MSH means the first line of a message and a new record is appended. EVN (and any other following headers) mean that information needs to be populated into the new record. I do not have the luxary of putting triggers on this table, so it needs to be done in the code. When a message has finished I need to be able to say, "Cool, it finished. Let's send something back telling the sender it went well." Then onto the next message in the big bunch of text.
>>>
>Does something like this work for you??????????
No, there could be different ones other than EVN. I knew I should have put all the case statement in, but I thought just showing the two would be good enough.
>
>llFirstRecord = .T.
>FOR EACH lineofText IN oText
> DO CASE
> CASE LEFT(lineofText,3) = "MSH" AND llFirstRecord
> llFirstRecord = .F.
> CASE LEFT(lineofText,3) = "MSH"
> SendCompletionMessage
> OTHERWISE
>
> ENDCASE
>
> DO CASE
> CASE "MSH"
> CASE "EVN"
> CASE "ETC"
> ENDCASE
>ENDFOR
>SendCompletionMessage