cmonthetic
IS-IT--Management
Hi,
Using Access 97.
I have a field in a database that has been populated from unknown means by persons unknown :| over several years.
The issue I have is that this field now needs to be split into 3 separate fields.
The data is in a very rough format of Alpha/Numeric/Alpha, e.g. WAR26A
However the data is not consistent and has been input in a variety of formats.
Following is some examples of the data:
WAR26A
029
WAR35
005B
50L
Also Null fields
The only consistent piece of input is that when the letters have been input at the start of a record they have always put 3 characters in e.g. WAR.
What I need to try and do is get the field split into the following 3 Alpha / 3 Numeric / 1 Alpha, but because there is so much variance in the inoput I am really lost as to how to begin sorting this out.
TIA
Using Access 97.
I have a field in a database that has been populated from unknown means by persons unknown :| over several years.
The issue I have is that this field now needs to be split into 3 separate fields.
The data is in a very rough format of Alpha/Numeric/Alpha, e.g. WAR26A
However the data is not consistent and has been input in a variety of formats.
Following is some examples of the data:
WAR26A
029
WAR35
005B
50L
Also Null fields
The only consistent piece of input is that when the letters have been input at the start of a record they have always put 3 characters in e.g. WAR.
What I need to try and do is get the field split into the following 3 Alpha / 3 Numeric / 1 Alpha, but because there is so much variance in the inoput I am really lost as to how to begin sorting this out.
TIA