I need some help regarding Extract with regex.
I would like to Extract only alphabets from the source and show it in a input box. In the below mentioned screenshot, I need the first Four letters of the Name column to be only alphabets.
Every value after an underscore comes from a different column. The first four letters come from a column called name. This column contains spaces, and special characters.
For Eg:
Business Names
- Tom & Jerry company
- The - American - Bikes
Required Output
- TOMJ
- THEA
I need to remove spaces and special characters using regex, can someone help me with the regex pattern for the same.





