Required to extract 1st and Last name from a obs using scan and compress

[animesh123]

If I have

Name:

Jack784Jill

Animesh56Mardi

Len7lenove

acer789542aspire

and wanted to extract 1st and last name only using scan and compress function 

[ballardw]

As a minimum you should indicate which part of those values is Last name and which is a first name.

[animesh123]

So as in example
1st_str
Jack
Animesh
Len
Acer

2nd_str
Jill
Mardi
Lenove

[ballardw]

Which actually does not clarify which is last name and which is first. Plus you have also changed the case of the string but only for some.

---

@animesh123 wrote:
So as in example
1st_str
Jack
Animesh
Len
Acer

2nd_str
Jill
Mardi
Lenove

---

[Patrick · Accepted solution]

Sounds like homework.

SCAN(string, count <, character-list <, modifier>>)

Use d as value for the modifier in scan function to define digits as the word separators, set count to 1 to extract the first word, and to -1 to extract the last word.