rpadminserver
Board Regular
- Joined
- Nov 7, 2007
- Messages
- 111
- Office Version
- 365
Hello all...
I'm hopeing someone can help me with some ACCESS SQL that will parse a comma delimited field into individual fields.
MY table name is TEST4A
I have a description field that looks like the following:
CUT 111.2, IBG-1, 2, B1-1NWLR
I have to parse this part of the data into 4 fields:
CUT 111.2, IBG-1, 2, B1
CUT 111.2 goes in the CUT_NAME field
IBG-1 goes in the LOCATION Field
2 goes into the Rack field
B1 goes into the Position field.
The description field will always have 4 parts to it, and those parts will always be comma seperated.
The last part (B1-1NWLR) I will always need to extract the first 2 char. There may or may not be a dash between the forst 2 char and the rest of the data in that section. Also the data after the dash will not always be the same number of char.
The description field and the 4 fields above are all in the same table.
As always thanks for any help!
I'm hopeing someone can help me with some ACCESS SQL that will parse a comma delimited field into individual fields.
MY table name is TEST4A
I have a description field that looks like the following:
CUT 111.2, IBG-1, 2, B1-1NWLR
I have to parse this part of the data into 4 fields:
CUT 111.2, IBG-1, 2, B1
CUT 111.2 goes in the CUT_NAME field
IBG-1 goes in the LOCATION Field
2 goes into the Rack field
B1 goes into the Position field.
The description field will always have 4 parts to it, and those parts will always be comma seperated.
The last part (B1-1NWLR) I will always need to extract the first 2 char. There may or may not be a dash between the forst 2 char and the rest of the data in that section. Also the data after the dash will not always be the same number of char.
The description field and the 4 fields above are all in the same table.
As always thanks for any help!
