S
Sparky
Hello,
I am new to access (2003) so may not use the correct terminology.
I want to extract a 'date' from a text field to populate another field. As
well I need to extract a string of numbers to fill another field.
SceneID=catDALI_a2155342430807171842022J_a26S5G2J200807171841140LMLMMX_satShift0_seg5278220.
The KJ to extract is 534243
The SceneDate to extract is 080717
The SceneID will always have the same structure.
I am new to access (2003) so may not use the correct terminology.
I want to extract a 'date' from a text field to populate another field. As
well I need to extract a string of numbers to fill another field.
SceneID=catDALI_a2155342430807171842022J_a26S5G2J200807171841140LMLMMX_satShift0_seg5278220.
The KJ to extract is 534243
The SceneDate to extract is 080717
The SceneID will always have the same structure.