This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a .txt file which has a lot of data shifts. The lines are breaking to next rows. I have created a dummy data that is similar to my data set. Is there any way we could spot and concatenate row 4,6 and 8 to 3,5 and 7 respectively?
I used a formula tool to Regex count the number of | in each record.
Then, with a multi-row formula tool, I have created a running total of the | count, and since you should have 5 | in each record (because that's how many fields you should have) I created groups using the mod function.
So then I had the field that I can use to group on, and with a summarize tool I could then proceed to concatenate the different fields.
Let me know if that worked for you or you have any questions on the workflow.