Hello! I’m merging several CSV files which all have almost the same form, except that in some files there’s a date in 3rd column, in others it’s in the seventh column. I was wondering if there’s any way to check if a cell contains a date type value, and if so to move it in the table? Help would be really welcome!
Here’s what I was thinking:
- Read CSV
- For each row -> If statement (to check if cell with index 6 contains a date)
- If so: move it to index 2
- Append datatable to Excel
I’m pretty sure this is the way to go, I just don’t know if there’s any activities or code I can use for this. Thanks in advance!