HTML </br> tag causing address issues

[taylorobbins12]

Hello, I have a doc of html code.  I broke it out by location, address.  Some of the files have an address2 line which are causing this issue, others dont and they are shown as below.

Student Center                            <br/>Albany, GA 31705

Is there a way in alteryx to split this into 2 seperate rows?  maybe with a formula?

What I want ex....

Student Center     

Albany, GA 31705         

thinking something like this............ if </br> then newRow         

Please let me know  

[MarqueeCrew]

I would filter the records based upon the count of fields. You've got a limited set of information in your sample. I'm just trying to show an approach rather than providing you with an exact workflow. Once you separate the records by content, parse the data and union it back together.

Regex_countmatches() will be useful to count the pipes.

Cheers,

Mark

[taylorobbins12]

ponraj 

How about selecting the row that starts with a number? As in an address, rather than a phone (xxx)?  I'm trying to split an address field into an address line and a blank row because there are no tags on this specific row to be able to split like you did above.