Sanitize comma-separated fields

[leendertvanwolfswinkel]

Some fields, such as time series fields, tags, and friction_values, contain comma-separated values.

If users have some spaces, newlines, tabs etc. in these, it fails. We could pretty easily sanitize these inputs before parsing them, saving our users a lot of hassle.

Fields involved

class	field	expected
Lateral2D	timeseries	comma separated numbers
BoundaryConditions2D	timeseries	comma separated numbers
Lateral1d	timeseries	comma separated numbers
BoundaryCondition1D	timeseries	comma separated numbers
many	tags	comma separated numbers
ControlTable	action_table	comma separated table
DryWeatherFlowDistribution	distribution	comma separated numbers
CrossSectionLocation	cross_section_friction_values	comma separated numbers
CrossSectionLocation	cross_section_vegetation_table	comma separated table
CrossSectionLocation	cross_section_table	comma separated table
Pipe	cross_section_table	comma separated table
Culvert	cross_section_table	comma separated table
Weir	cross_section_table	comma separated table
Orifice	cross_section_table	comma separated table

Actions for comma separated strings

Remove white space surrounding , and remove leading and trailing white spaces, including tabs and new lines

• 1,2,3 -> 1,2,3
• 1, 2, 3 -> 1,2,3
• 1 2 3 -> 1 2 3
• 1,2, 3 -> 1,2,3
• 1,\t2,\t3\n -> 1,2,3

Actions for tables

Remove leading and trailing white space and then do the above for every item