Hello all,
Through regex I was able to remove only 1st line yellow highlighted data & keep operation column values only
but when the same yellow data values are dynamic as mentioned below then unable to remove all column data except op
need only last column data which starts after N
Hello Chethan,
Can you send the regex you used to do this?
Probably you will have to use ‘*’ in your regex for the part which might be null in some cases i.e., to indicate 0 or more occurrences.
It’s not selecting the lines as required when lines are dynamic
Thanks
Chethan M
This is regex code
\d{1,2}:\d{1,2}\s*\d{1,2}.\d{1,2}\s*(\d{1,2}\s\d{1,2}/\d{1,2}|\s*|\w*)\s*(\w*|\s*)\s*(\w*|\s*)\s*\w{1}
Can you share string you get? do you retain formating?
Ajay_Mishra
(Ajay Mahendra Mishra)
7
@Chethan_M1 Can you send this txt file or if its confidential then some dummy data, I can help you in this!
Regards,
Ajay Mishra