Updating number syntax

The SPIN substances are registered with CAS numbers, EC numbers and Index numbers. Each of these numbers are registered in the database with and without the format enhancing “-“. If the upload only contained the number in one of these formats, you have three database controls for calculating the other version. Each databse control will add any missing version of the number from the other, i.e. if the CAS number was uploaded in the format 50-00-0 and the format (PID) 50000 is missing, then this control will calculate and register it. And vice versa.

If you need to do a similar change in an Excel spreadsheet, you can remove any “-” by selecting the column and using “replace” to substitute “-” with “” (nothing).

If you need to add “-” to a PID in cell A2 in order to show the PID formatted as a cas-number you can use this formula:

=VENSTRE(A2;LÆNGDE(A2)-3)&”-“&MIDT(A2;LÆNGDE(A2)-2;2)&”-“&HØJRE(A2;1) (In a danish version of excel)

=left(A2;length(A2)-3)&”-“&middle(A2;length(A2)-2;2)&”-“&right(A2;1) (english version of Excel)