Hi I have a dataset and and I have to fetch some values after that number
Example:
Example:
Input:
String | Number after |
\abc_Apple\folder\Num1234\apple\fruit123.xlsx | 1234 |
\ac_Appl\Num124\P01-P12\fruit123.xlsx | 124 |
\abcd_Appl\Num134\B12_B12\fruit123.xlsx | 134 |
\\abced_Apple\12Num1234\Bannana\fruit123.xlsx | 1234 |
The number and backslash word/Code backslash -> I want to extract the code/word in between the backslash and after number
Output:
String | Number after | Result |
\abc_Apple\folder\Num1234\apple\fruit123.xlsx | 1234 | apple |
\ac_Appl\Num124\P01-P12\fruit123.xlsx | 124 | P01-P12 |
\abcd_Appl\Num134\B12_B12\fruit123.xlsx | 134 | B12_B12 |
\\abced_Apple\12Num1234\Bannana\fruit123.xlsx | 1234 | Bannana |
@binuacs The backslash could be anywhere, Sorry I did not mention it. So regex should be based on the number after column and after we should pick the value
@Sshasnk try the below regex