Data Parse

[EvansM]

Community,

Please refer attached file. I need help to parse the data like the example shown in the file attached.

Thanks

[AlteryxUserFL · Accepted solution]

I think a find and replace tool will accomplish what you need. Let me know if this works.  

[LukeG · Accepted solution]

Hey @EvansM 

Here is a solution using the formula tool.

Using the replace function we first replace the "." with a space (" "), then we replace any consecutive spaces ("  ") with a single space (" ") in step 2.

Workflow is attached. Let me know if you have any questions!

Luke

[EvansM]

Thanks It works fine