same text (1 Viewer)
- Thread starter amberjen
- Start date
First, discrete data should be stored distinctly. You shouldn't jam pieces of data that each have meaning into one field. Your data should be in 2 fields so you don't have to programatically seperate it.
Now that you are there however, you would use the Mid function (https://www.techonthenet.com/access/functions/string/mid.php) and possible the Instr function (https://www.techonthenet.com/access/functions/string/instr.php)
Now that you are there however, you would use the Mid function (https://www.techonthenet.com/access/functions/string/mid.php) and possible the Instr function (https://www.techonthenet.com/access/functions/string/instr.php)
- Local time
- Today, 12:07
- Joined
- Feb 28, 2001
- Messages
- 27,146
Or if it is ALWAYS delimited by "-" then look into the SPLIT function. But if the delimiter is NOT always "-" (e.g. NO delimiter, as shown in your second example), then you have a much worse problem on your hands. You would have to parse this backwards to find the first non-digit character when testing from right to left.
