karinos57
asked on
how to split text in access into 2 fields
Hi,
I have a field like the following:
4mg/Acc
3mgkl/Mllpr
LLMN/Gkoh
So all what i want to do is that split the text into 2 fields starting the "/". Here is the result that i would like to see:
field1 field2
4mg Acc
3mgkl Mllpr
LLMN Gkoh
Thanks.
I have a field like the following:
4mg/Acc
3mgkl/Mllpr
LLMN/Gkoh
So all what i want to do is that split the text into 2 fields starting the "/". Here is the result that i would like to see:
field1 field2
4mg Acc
3mgkl Mllpr
LLMN Gkoh
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this is perfect
select Left([f1],instr([f1],"/")-
mid([f1],instr([f1],"/")+1
from tableX
where Instr([f1],"/")>0