It generates:
Name,Machine ID,Product,Type,Start,End,
The expected data should not have a comma at the end like:
Name,Machine ID,Product,Type,Start,End
Each line also has a trailing comma.
This seems very inconsistent with any csv I have worked with, and a simple import of the file into python for example generates the following (see attachment). The 6th field should not exist.
You can see this from a simple csv reader like:
import csv
with open(r"D:\temp\NinjaTrader Grid 2022-03-05 02-01 PM.csv") as fp:
reader = csv.reader(fp, delimiter=",", quotechar='"')
data_read = [row for row in reader]
print(data_read)
Comment