These are just samples of a huge dataframe

```
Sample1
                       col1                            col2
1      123001 124003 125699 348348 3493493 1230404 99930202
2 29238822 293831232 992922 348348 3493493 1230404 99930202

```

Sample1 has set of numbers in each cell(separated by space)

```
Sample2
        col1  col2
1     123001   CAT
2   99930202   PIG
3     124003   ODG
4    1230404 CHAIN
5   29238822   BAT
6  293831232 MOUSE
7    3493493  KIWI
8     125699   JIN
9     992922 ANIME
10    348348  UPPE

```

If a match exists for the numbers in Sample2 table, the corresponding value in Col2 of sample2 table should be pulled up.

A final desired output would be below.

```
Output
                   col1                                col2            col3
1      123001 124003 125699 348348 3493493 1230404 99930202     CAT ODG JIN
2 29238822 293831232 992922 348348 3493493 1230404 99930202 BAT MOUSE ANIME
                 col4
1 UPPE KIWI CHAIN PIG
2 UPPE KIWI CHAIN PIG

```

I have tried using different methods merge, join, sqldf but unable to get my output. Can anyone please help?