Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Removing a particular statement

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 t...
Need Help
PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

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's avatar
ganeshnr073
Helper I
3 years ago

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