I am trying to locate numbers within views where the text of the view is in a long format. I have already been able to convert the `long` to a `char`.

I have been messing around with `replace` and `instr` functions but haven't been able to get it out neatly.

Ideally I would like to populate a table with the following information.

the user (grantee) of the view, the ID values that are in the file, 1 row for each ID.

A sample view would be something like this.

```
Select column1, column2, column3 from table_with_data where ID in (1,5,322,54,12)

```

or 

```
Select column1, column2, column3 from table_with_data where ID = 2

```

How could I create 5 rows in a table just pulling the numeric values here in the first case and just 1 for the second?