How to merge lines in a text file

Hello,
I am dealing with an industrial tool script that I need to translate into a value matrix.
You will find below a sanitized sample.

At each step, input commands are separated by a comma. and a final semicolon indicates the end of the step.
My problem is that the commands are spread over several lines. See below.
After opening the file, I want to merge all the commands into a single line, prior to transfer to a worksheet.

I imagine that I need to make a test on the last character.
If last character "," then deleted carriage return and repeat test

Is there an Excel VBA code to do that ?


Thanks for the help !


45 "H, Initial setting",
N.line close, N.run close, H.line open, H.run open,

X.source = 100, y.source = 10, y.push = 100,
RunHydrid = 100, RunMODopant = 500, RunMO to 2000,
a = 500, b = 2000, www off;

It worked.
Thanks a lot.