in-field separator different from csv-separator (ln 38),
csv-file utf8 encoded and csv-delimiter to semi-colon (ln 62)
Line 38:
The in-field delimiter should be something different from the csv-delimiter and an often used character in the display name of users:
e.g. Peter Smith and Paul Black are often referenced with display names "Black, Paul" and "Smith, Peter" which leads to a owners field value in the script's output of "Smith, Peter, Black, Paul". There was simple solution to separate owners in MS PowerQuery to individual rows/fields by the "," delimiter. Therefore I changed the delimiter to "|".
Line 62:
The default csv-delimiter "," lead to false records when loading the csv into columns in excel as the team names haven't got stringed in ""s and a comma is a valid character in a team name. Therefore changed this to ";" and included UTF8 encoding for all the special characters in European languages.
12Knocksinna
commented
1 year ago
Minor improvements
Line 38: The in-field delimiter should be something different from the csv-delimiter and an often used character in the display name of users: e.g. Peter Smith and Paul Black are often referenced with display names "Black, Paul" and "Smith, Peter" which leads to a owners field value in the script's output of "Smith, Peter, Black, Paul". There was simple solution to separate owners in MS PowerQuery to individual rows/fields by the "," delimiter. Therefore I changed the delimiter to "|".
Line 62: The default csv-delimiter "," lead to false records when loading the csv into columns in excel as the team names haven't got stringed in ""s and a comma is a valid character in a team name. Therefore changed this to ";" and included UTF8 encoding for all the special characters in European languages.