matthiaskoenig / pkdb

Pharmacokinetics database
https://alpha.pk-db.com
29 stars 6 forks source link

Restrict allowed characters in field #681

Open matthiaskoenig opened 3 years ago

matthiaskoenig commented 3 years ago

This is related to https://github.com/matthiaskoenig/pkdb_data/issues/1058.

I wanted to restrict the allowed characters in cells (i.e. table fields) for long. Strange characters create a ton of problems in subsequent computational processing. Restrict allowed characters to [0-9][a-z][A-Z]['_', ' ']. I.e. only alpha-numerical and whitespaces. Especially things such as + and / should not appear. Also ensure that labels do not start with numbers. Basically these should be close to valid SBML Sid values. This allows to use these directly as variable names. This will break a lot of studies, but will make it much easier to work with the data afterwards.