I'm trying to import multiple CSV files, the "import multiple files" function doesn't work well because original data column name format has two problems that will cause title and data don't match
1. The data column name looks like this: Date time name ( A B C ) (D E F ) height weight ......etc
2. The dilim I need are space and ( and )
3. However, there is additional space or tab before "Date", so the first column name becomes Column 1 rather than Date, and data right shift one column compare to title
4. second error is (D, there in no space between this two for the title, so they are treated as one title, but the data are separated into ( and D two columns because there is space in between, so data will left shift one column compare to title
5. The first error always exist before first column name "Date", but the second error "(D" may appear at different order based on source tool
The
