I am trying to convert a numbering system in an old dbase file. I have manage to open it in calc and, before I use it as a table in a new database created with base, there is a field (column) I would like to modify.
The actual format is ex : 100-1234-56 I would like to:
add a 1 in front of it, keep the first 3 numbers, remove the dash, keep the next four numbers and remove the dash with the last 2 numbers like this:
100-1234-56 would be 11001234
What are my options ?