Junk values coming in to Website field

My CRM sends non Website data like "Website not found" , "Website under construction" etc and there is a validation to receive only data like WWW.abd.com, www.abd.com, starts http and ends with .com , .com,in, .in. Because of this data issue the integration stops and requests flow comes to a halt.

How do i use RegEx tool or any other to exclude all of the valid formats and through out the text values using an excel and send in an email. I want to do this from my SQL table into which my CRM pushes the data.

Email with errors from SFDC.yxmd

Salesforce

Accepted answers

atcodedog05

Hi @Nageswar_GEM

If you want capture rows with values "No Website found", "Website not working", Website Under Construction". You can use a filter like below. You can add more status code in the list (within the bracket) to check.

Hope this helps🙂

website.yxmd

All comments

atcodedog05

Hi @Nageswar_GEM

Can you provide some sample data and expected output. So that we can help out. Current workflow has a db connection hence we wont be able to get a sample data.

Nageswar_GEM

as i mentioned the values i get are "No Website found", "Website not working", Website Under Construction". So if these kind of non website format values are coming then should be highlighted and pasted in an excel output.

now i have the WF attached. The input file has the last column, Website. Please advise how to generate an output only for the non website data like NULL, Website Not found, Website Under Const.

Email with errors from SFDC.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703