How to extract particular text from below string

[sambulkar]

How to extract text before HCCLAIMPMT from the below text?

Absolute Total C HCCLAIMPMT 040121 CCD/

[prasath17 (Guru)]

@sambulkar - Already responded here…

How to extract particular string from text?

@sambulkar - I misread your requirement… .+(?=\s+HCCLAIMPMT) [image] Please open up a new forum query in future, if its different from your original query.