Excel 365 import tool does not function with multiple delimiters

Question

[Tue Dec 03 14:59:01.594 2019] 26.3,1.5,27.7,30.2,915.6,1579,83.3,1.614721,0.093,110.2,00,03/12/19,17:53:20,80

In the past, I imported the csv file by delimiter ","

Saved new csv file

Imported by delimiter of "]"

saved a new csv file

then imported by delimiter of "["

I am being forced to use Python, etc, since Excel does not work anymore in this fashion.

I am just missing something?   Is there a way to do with in this new version of Excel?

Thanks

Steve

Answer 1

Hello SBoddeker

I am V. Arya, Independent Advisor, to work with you on this issue. After importing with comma, no need to save it as a new csv.

Just select your first column, go to data tab, click text to columns,

Select Delimited on first screen

Next, in other put ] and Finish

Repeat the above for [

You will need to take care that existing data doesn't get overwritten.

Answer 2

Thank you very much

This worked well