'How to create mysql data with specific CSV file strings

I have csv file which has data as in following format(data has converted from rrd to csv)

.....   
......  
<database>
<!-- 2022-04-26 22:04:00 +0530 / 1650990840 --> <row><v>5.0000000000e+00</v></row>
<!-- 2022-04-26 22:05:00 +0530 / 1650990900 --> <row><v>5.0000000000e+00</v></row>
<!-- 2022-04-26 22:06:00 +0530 / 1650990960 --> <row><v>5.0000000000e+00</v></row>
</database>
....
.....

Are there any method to extract 2022-04-26 22:04:00 +0530 as the date,1650990840 as num1, 5.0000000000e+00 as num2?

Final output should be as follows,

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source