I have below sample data and need output as mentioned.
Can you please suggest.
Input
XYZ,DATA,G:\Data\XYZ\DATA\Test1.txt,1234,01/01/2025 14:17:14
XYZ,DATA,G:\Data\XYZ\DATA\Test2.txt---bkp,sfsfsf---,12345,01/01/2025 14:17:14
XYZ,DATA,G:\Data\XYZ\DATA\Test3.txt@#ttabd--.txt,123456,01/01/2025 14:17:14
XYZ,DATA,G:\Data\XYZ\DATA\Test4.txt,1234777,01/01/2025 14:17:14
XYZ,DATA,G:\Data\XYZ\DATA\Test5.txt,123479878,01/01/2025 14:17:14
Output
XYZ,DATA,1234
XYZ,DATA,12345
XYZ,DATA,123456
XYZ,DATA,1234777
XYZ,DATA,123479878
Note : 3rd column is path and file name but file name is having different extra character like , @-- etc, so I am getting blank and output is coming correctly.
... View more