Hello Team,
I want to remove Prefix & Suffix from the raw data. Output data should data after removing it. In this example i want product id withwithout collon data
Input Data is like below: Prefix & removal to apply on Product ID.
| Product ID | Product Name | 1st level Approval status | Date |
| 17I:634534:V9 | C | WIP | 2019-10-29 |
| 17I:3019IA:V2 | W | Submitted | 2019-12-11 |
| 18I:423123:V1 | s | Accepted | 2019-12-13 |
| 18I:1323451:V2 | q | In Transmit | 2020-01-10 |
| 19I:98765:V3 | r | In Transmit | 2020-01-16 |
| 19I:234567:V1 | e | Submitted | 2019-12-11 |
| 19I:234987:V4 | u | In Transmit | 2019-10-27 |
| 343011_2018 | W | Submitted | 2019-12-11 |
| 12345-2019 | s | Accepted | 2019-12-13 |
Output Data required like below:-
| Product ID | Product Name | 1st level Approval status | Date |
| 634534 | C | WIP | 2019-10-29 |
| 3019IA | W | Submitted | 2019-12-11 |
| 423123 | s | Accepted | 2019-12-13 |
| 1323451 | q | In Transmit | 2020-01-10 |
| 98765 | r | In Transmit | 2020-01-16 |
| 234567 | e | Submitted | 2019-12-11 |
| 234987 | u | In Transmit | 2019-10-27 |
| 343011 | W | Submitted | 2019-12-11 |
| 12345 | s | Accepted | 2019-12-13 |
