true.....:) ... View more

Thanks for the reply. This approach might work when I have a raw event with 3 columns. However, ColumnB is an extracted field and there are other columns as well. This approach changes the search results entirely. ... View more

Thanks for the reply. 2nd approach was getting the results but realized different use cases in the data. As a result, most of the data is ignored. Updated the question with updated pic to represent those use cases. ... View more

I included a sample event as a image. ... View more

Thanks again...yes. It did the trick. Moreover, regex101.com is a great tool. ... View more

Thanks a lot mate. Yes, it worked as wanted. In the end if I want to add BC??- to AB??- how should I add these two. ... View more

There are thousands of lines, just sampling few lines. This data is coming from comments people write for specific hardware and is not generated by a machine. Thus, it is highly random. The raw data is as follows. Additionally this data is present in a specific column. After the search the first 6 rows should be the final result. 1 1401812.AQWEAB02-TCPL02.1G 2 1356292.QWERAB04-ANCA02 3 1234OAB05-PLAIN02 reserved || 4 1405252.AB07-SBCC01 5 1409325-ARDRAB05-GENIV02.22 6 1304030.ARDRAB07-TECEL02.10333 7 1389621.ABFDBC01-COGDS02333 8 1349222.ABFDBC01-MOH29.5MJJ 9 1313513.ABFDBC01-BPRSS 10 1393599.ABFDBC01-WGELP 11 1375957.ABFDBC01-BREQL01.0M222 12 1332348.ABFDBC01-MANNG01.10M1WW1 13 1321017.ABFDBC01-BLJCW01.3MQQ Moreover, it is not only AB??- that I would be searching for, there are other criteria as well but I guess if we can get one criteria down then others should follow the same pattern. ... View more

Thanks for the reply. I must confess I am encountering makeresults for the first time, so trying to wrap my head around the search cmd. AB22-,AB43-,AB03-,AB1233-,ABw-,AB22222222- is not my raw data, it was just an example. The cells contain data with a pattern of ABXX- and I want to filter only those records in a specific column which follow that specific pattern. I did come across filter option when converting data into Data Table. However, still no success. ... View more

Thanks in advance. I got the following error. Error in 'rex' command: Encountered the following error while compiling the regex 'AB(?\d\d)-': Regex: unrecognized character after (? or (?- ... View more