I have a list of string, where I have to fetch numbers from. The number will be there after a word Num
Example:
Input:
| String |
| \abc_Apple\Num1234\fruit123.xlsx |
| \ac_Appl\Num124\fruit123.xlsx |
| \abcd_Appl\Num134\fruit123.xlsx |
| \abced_Apple\12Num1234\fruit123.xlsx |
Output:
| Value |
| 1234 |
| 124 |
| 134 |
| 1234 |
Solved! Go to Solution.
@Sshasnk
We can use RegEx
