How to work with multi line test file's contents.

dizy_11

Hi all,

So i'm working with multi line test file. I have imported the file as fixed delimiter to import it. It's data is too much ununiform.  My input is like this:-

There are lots of similar pattern of data in the file. I have just created a random sample of the file.

I want to convert all these data to separate columns. My output should look like this:

Can anyone please help me how to achieve this.

input.xlsx

atcodedog05

Hi @dizy_11 

Here is how you can do it. I am assuming to similar blocks like this one below other.

Workflow:

1. In Input tool configure it to First rows contains data like below.

2. Using Multi-row formula tool to create blockID/rowID on each occurrence of "Address" keyword in row.

3. Using summarize tool to concat rows for each blockID.

4. Using data cleanse tool to remove extra spaces.

5. Using regex tool to parse the data.

Hope this helps : )

Report parse.yxmd