Can anyone help me with the following?
I have a spreadsheet containing data having IP addresses in which I need to create a output text file.
A sample input file would look like this
the output .txt file would look like this
Thanks
I have a spreadsheet containing data having IP addresses in which I need to create a output text file.
A sample input file would look like this
| owner | active | group | address | exp |
| a | 1 | gray | 10.10.10.10 | 1/1/2023 |
| b | 1 | blue | 10.10.10.12-10.10.10.15 | 1/1/2023 |
| c | 1 | red | 10.10.10.20-10.10.10.25, 192.168.1.1-192.168.1.2,192.168.10.10 | 1/1/2023 |
the output .txt file would look like this
| owner | active | group | address | exp |
| a | 1 | gray | 10.10.10.10 | 1/1/2023 |
| b | 1 | blue | 10.10.10.12 | 1/1/2023 |
| b | 1 | blue | 10.10.10.13 | 1/1/2023 |
| b | 1 | blue | 10.10.10.14 | 1/1/2023 |
| b | 1 | blue | 10.10.10.15 | 1/1/2023 |
| c | 1 | red | 10.10.10.20 | 1/1/2023 |
| c | 1 | red | 10.10.10.21 | 1/1/2023 |
| c | 1 | red | 10.10.10.22 | 1/1/2023 |
| c | 1 | red | 10.10.10.23 | 1/1/2023 |
| c | 1 | red | 10.10.10.24 | 1/1/2023 |
| c | 1 | red | 10.10.10.25 | 1/1/2023 |
| c | 1 | red | 192.168.1.1 | 1/1/2023 |
| c | 1 | red | 192.168.1.2 | 1/1/2023 |
| c | 1 | red | 192.168.10.10 | 1/1/2023 |
Thanks
