Removing a particular statement

[Anonymous]

Hi, 

I'm trying a to remove a predifiened statement. I'm importing it from SharePoint list, the statement is predefined and does not change. I am attaching the message below.

Need to remove the below message from the sentence.

Thanks

"Company -- This message is transmitted to you by or on behalf of
Company or one of its affiliates. It is intended exclusively for
the addressee. The substance of this message, along with any attachments, may
contain proprietary, confidential or privileged information or information that
is otherwise legally exempt from disclosure. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient
of this message, you are not authorized to read, print, retain, copy or
disseminate any part of this message. If you have received this message in
error, please destroy and delete all copies and notify the sender by return
e-mail. Regardless of content, this e-mail shall not operate to bind
Company or any of its affiliates to any order or other contract
unless pursuant to explicit written agreement or government initiative expressly
permitting the use of e-mail for such purpose."

[PhilipTreacy]

Hi @ganeshnr073  @Anonymous 

My code does replace the entire statement with blank - except for the company name which I can't account for as I don't know how to remove that with the information you've provided.

Can you supply some examples of your data?  Perhaps the cmpany name can be found in another row, or perhaps can be removed some other way.

Please supply some sample data.

regards

Phil

[PhilipTreacy]

Hi @Anonymous 

Is the statement exactly as you've shown?  Specifically I am wondering if the word Company is replaced by a company name?

If it is actually the word Company, you can right click the column header and use Replace Values 

Replacing the entire string with nothing

Before

After

If the word Company is actually a company name, you'd probably need to know the company name to remove that piece of the string.  If this is the case, can you please post some examples of the whole text that this statement occurs in.  Plus any other data in the row.  If the company names appears in another column, you could use that to remove the company name from the statement.

Regards

Phil

[ganeshnr073]

Hi @PhilipTreacy 

Thank you for your reply.

Yes the Company will be replaced by a comapny name.

Actually my requirement is to remove the whole statement not to replace a particual value. I'm capturing an eamils and updating in a list and pulling that into Power BI. So I do not need the whole statement and should be replaced by a blank.

Thanks