Hi, I was wondering how to split for each row in a datatable. For example, a column of my datatable looks as follows: . I would like to know how to split them by space without having to read the excel range (if that is possible).
The process I took was as follows:
- I made a datatable using regex to find information in a PDF file.
- The second column consists of the regex information (which happens to look like the image above)
- I read that onto an excel sheet.
So my question is in a sense, is like how to do text to column in excel, but the datatable version.