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 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 then newRow Please let me know

HTML </br> tag causing address issues

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

Developer Tools

Accepted answers

MarqueeCrew

Because @LordNeilLord asked I've added a quick parse of the html. I don't quite get the data question, but here's my take on how to read it.

I used my eyes and did replacements. I saw text followed by spaces and decided to place pipes as replacements. Then I repeated this until I created something workable. This might not be the "answer", but it should help.

Cheers,

Mark

Help for LNL.yxmd

All comments

ponraj

HTML tag causing address issues-Solution.yxmd

LordNeilLord

Hey @taylorobbins12

Using the regex tool in tokenize mode place <\/br> as the criteria and select split to rows

This will split on line breaks

Neil

taylorobbins12

Thank you for your quick response! That worked, but not all elements of my HTML have that issue. I have attached an example of my data with some having address only and other having address and address 2. In my final output, I am looking to have a table with Location, Address, Address2, City, State, Zipcode, Phone Number. Please let me know if you can help.

practice.txt

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703