narayanan28997
New Member
- Joined
- May 14, 2019
- Messages
- 2
Could you please help me to code the following:
I need to pick only the integers/float from a particular line of the text file (say line 2 qnd 3) and store it in an excel with each integer in a separate cell in sequence?
text file:
[Page1]
MotorP_AvgTemp= 10, 11, 1.25
MotorP_PackVoltage= 60, 32, 23.32
excel output:
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I need to pick only the integers/float from a particular line of the text file (say line 2 qnd 3) and store it in an excel with each integer in a separate cell in sequence?
text file:
[Page1]
MotorP_AvgTemp= 10, 11, 1.25
MotorP_PackVoltage= 60, 32, 23.32
excel output:
10 | 60 |
11 | 32 |
1.25 | 23.32 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>