M
Marie
I am trying to extract numbers from a string of text. For example, the data
I have are:
AMHERST /IN: CK 623
CASA NINOS OF MONT/IN: CK 8996
MONT SCH OF MANHA REF:954
MONT SCH OF DOWNT REF:10136
THE MIAMI MONT SC REF:1070
RESTON MONT SCH REF:13926
DAKOTA MONT SCH REF:15069
What I want to extract is the following:
If there is a "CK" (check #), I want the number value in one column.
If there is a "REF:", I want the number value in another column.
As shown above, the numbers can be of varying length.
Can someone tell me how I can do this?
I have are:
AMHERST /IN: CK 623
CASA NINOS OF MONT/IN: CK 8996
MONT SCH OF MANHA REF:954
MONT SCH OF DOWNT REF:10136
THE MIAMI MONT SC REF:1070
RESTON MONT SCH REF:13926
DAKOTA MONT SCH REF:15069
What I want to extract is the following:
If there is a "CK" (check #), I want the number value in one column.
If there is a "REF:", I want the number value in another column.
As shown above, the numbers can be of varying length.
Can someone tell me how I can do this?