Here is my problem.
I have a file the field in question looks like this
13 main st
134 red rd
2 main road
952A north land
I want the 1st part in one field and the 2nd in another. I can not do unstring delimited by ' ' because the second field will only have the 1st word.
I then tried this:
unstring c-addr
into pacc-house-no delimited by ' '
pacc-street-name delimited by ' '.
But this is not correct.
What can I do if anything?
Thanks so much
I have a file the field in question looks like this
13 main st
134 red rd
2 main road
952A north land
I want the 1st part in one field and the 2nd in another. I can not do unstring delimited by ' ' because the second field will only have the 1st word.
I then tried this:
unstring c-addr
into pacc-house-no delimited by ' '
pacc-street-name delimited by ' '.
But this is not correct.
What can I do if anything?
Thanks so much