+8
Hi
I have populated a column with an email body. Now I need a regex to remove all the text from the column that I do not need. I only need the 1st few sentences of the email body.
What Reg ex can I use? Is there one that saids remove all text after a certain word?
Thanks
+8
The reg expression result is ;
I have line breaks and spaces in the column I am pulling from. I not sure if this makes a difference.
+8
Hi Paul
I managed to do a work around. I think the issue might be a line break.
Example:
data 1: 123 Data 2: 123 Data 3:123
Data 4:123
Dear who ever...
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I want to remove the text from Dear onwards to leave only the data columns.
Hi Michelle Goodman
Try this:
[sS]*(?=Dear)
With the input text above, the result is
data 1: 123 Data 2: 123 Data 3:123
Data 4:123
;
You will have line breaks in it but you could do another regex set to replace, using the pattern and replacement text leave empty, which would remove the line breaks and you would have:
data 1: 123 Data 2: 123 Data 3:123Data 4:123 ;
Hope this helps
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
