segp14 issueshttps://git.soton.ac.uk/segp14-2021/segp14/-/issues2021-03-06T17:53:51Zhttps://git.soton.ac.uk/segp14-2021/segp14/-/issues/2How should the error checking for CSV file format be done?2021-03-06T17:53:51Zpm3g19How should the error checking for CSV file format be done?When the CSV file will be read, we will need to ensure that the values are in the correct format e.g. Male/Female are correctly spelt and age ranges are in the form of <number>-<number> and they need to be converted into a more computati...When the CSV file will be read, we will need to ensure that the values are in the correct format e.g. Male/Female are correctly spelt and age ranges are in the form of <number>-<number> and they need to be converted into a more computationally-friendly type. How should this be done: in Java using regex or SQL? Does SQL have nice string manipulation functions?https://git.soton.ac.uk/segp14-2021/segp14/-/issues/1Should error messages for CSV files be detailed?2021-03-06T14:07:32Zpm3g19Should error messages for CSV files be detailed?