Read unstructured csv file to datatable

Help
1

hi guys i want to read this unstructured csv file and convert it to datatable,

image
image1073×124 7.93 KB

the column would be Name, Database Version, IP Address, Last visible Time, Type of operating system, etc.
example 1st row :
Name : EJK1KEUD28
Db version : 14/08/2017 06:50:10
IP address : 10.163.216.53
Type of os : Microsoft Windows 10
Agent installed : Yes
Network agent version : 10.5.1781
Application version : 10.3.0.6294
Real-time protection status : Stopped
icon created : 17/01/2019 16:22:28

how can i achieve this ?

2

Last Visible Time : 15 minutes ago

3

Hi @RobertoEwaldo,

Here in csv names & all field length is constant,Then we can convert first horizontal rows to vertical rows & see

5

can u tell me how ?

6

Hi @RobertoEwaldo,

Use regular expression & get the data,Then arrange data accordingly