I have a table that has multiple items in a field delimited by a "-"
and I am looking for a way to sort through these.
For example here is what one field might look like:
- 007310 - ENCR - 015968 - 019838 - 10193 - REPORT - PERST
an I would like to put the items in this field (and for all other records)
in numerical order.
Is there an easy way to do this?
Thanks
and I am looking for a way to sort through these.
For example here is what one field might look like:
- 007310 - ENCR - 015968 - 019838 - 10193 - REPORT - PERST
an I would like to put the items in this field (and for all other records)
in numerical order.
Is there an easy way to do this?
Thanks