Fix soliTOC csv colnames

Automatically fix shifted colnames in soliTOC excel exports.

fix_soliTOC_colnames(
  soliTOC_raw_excel,
  save = F,
  save_location = "keep",
  return = T,
  Date_Time_colname_position = 6,
  time.col_name = "Zeit"
)

Arguments

soliTOC_raw_excel

An Excel file as exported from soliTOC software

save

Should the fixed df be saved as csv? Default FALSE

save_location

Optional: a filepath (C:/dir/other_dir/myFile.csv), where the fixed df should be stored as csv. Default is "keep". This uses soliTOC_raw_excel to get a filepath and saves output as basename_fixed.csv

return

Should the output be returned? Default TRUE

time.col_name

Used as failsafe. Checks if the time.col_name string can still be found in the date column name. If TRUE, proceed, else stop (already fixed column name), because function would shift colnames wrongfully.

Date_Time_colname_postion

For comparability: Which column contains the separated Date and Time entry? Default is the 6.