Adaptive split string

[GoldenDesign04]

I have a data set that is used to update a CRM type tool. The requirements on this data update are sketchy and frankly weird. I'm hoping a meeting with them can shed light into this process and prevent me from having to entertain such a potential issue as I present to you now. 

The data is an extract of website urls seen below:

URL

www.moodyradio.org/indiana

wbkwradio.com

www.973joefm.com

www.wixe.com

mytalk1071.com

www.am1460wixn.com

www.rivercountry1017.com

www.1057thexrocks.com

www.greatesthits981.com

The CRM needs a space separation between all words, including station lettering so the output would look like this:

URL	CRM Load
www.moodyradio.org/indiana	www. moody Radio .org/indiana
wbkwradio.com	wbkw radio .com
www.973joefm.com	www. 973 joe fm .com
www.wixe.com	www. wixe .com
mytalk1071.com	my talk 1071 .com
www.am1460wixn.com	www. am 1460 wixn .com
www.rivercountry1017.com	www. river country 1017 .com
www.1057thexrocks.com	www. 1057 the x rocks .com
www.greatesthits981.com	www. greatest hits 981 .com

Why the data needs to be formatted as such is beyond my knowledge right now. I've used Python to make simple word analysis based on key words in comments sections scrapped from the web but never something this complex.

Any suggestions input on if Alteryx could assist in this process?

[Amarendra · Accepted solution]

Hi @GoldenDesign04 

I don't think there is no direct or faster way to solve this. At a glance, my thoughts are to use the python tool and a text analytics package that might help parsing out words from a sentence.

You can then use formula tools to add spaces in between each word or use PIVOTING based on the output from the parser.