Extracting strings from rows

[Kuldeepmathur]

HI,

Need to extract Id and their belonging location. I am able to extract Ids but could not be able to map the location to the specific Id.

Expected results : 

Texas  22

Texas  24

Thanks,

Kuldeep

[JarekSkudrzyk]

@Kuldeepmathur hi, please take a look at my solution - does it solve your problem?

[Tyro_abc]

@Kuldeepmathur  here is my try, I tried to make it dynamic. This should work even if you have different digits in user ids or more than one "Or" clause. 

Input 1

Input 2: ( Alpha-Numeric)

Output 1

Output 2( Alpha-Numeric)

Regards

Arundhuti

[Tyro_abc · Accepted solution]

Slightly modified version ( two different containers have two different versions) 

Regards

Arundhuti

[Kuldeepmathur]

Thanks Everyone :)