Clean up unwanted addresses.

[SwatzJaswal]

Hey team,

I have a requirement in which I need to mark the invalid address with 'Fraud'. Below is the sample input and requirement output:

Input

Output:

[grazitti_sapna · Accepted solution]

@SwatzJaswal , Here is a how to can achieve your output. Please remember this solution is based on the data you have provided. As I have used Regex you might have to add or make changes in current regex format as per the data set.

[ShankerV]

Hi @SwatzJaswal 

One way of doing this.

Where we check the St.