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?[Page1]MotorP_AvgTemp= 10, 11, 1.25MotorP_PackVoltage= 60, 32, 23.32
Output in excel:
[TABLE="width: 170"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]1.25[/TD]
[TD="align: right"]23.32[/TD]
[/TR]
</tbody>[/TABLE]
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?[Page1]MotorP_AvgTemp= 10, 11, 1.25MotorP_PackVoltage= 60, 32, 23.32
Output in excel:
[TABLE="width: 170"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD="align: right"]1.25[/TD]
[TD="align: right"]23.32[/TD]
[/TR]
</tbody>[/TABLE]