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.
Here's my 1st cut of the workflow. Like I mentioned in my first post. Flat files are tricky. You have to break them down into groups depending on the type of data in the row. I parse the header rows, data value rows, percent rows and "All companies" rows separately and recombine them all and sort by a RecordID field that I added early in the work flow
Using your second data file, stored in the same directory as the workflow, the results are as follows. This is assuming that you alternate data and percentage rows and that you remove the extra space after the initial customer number.
I'll leave it to you to output in the format of your choosing
This is absolutely phenomenal!! Never in a million years would I have known to try something like this. Thank you so much!! Going to take me a bit of time to go through and understand all the steps you took. It seems like the base of being able to do this was using the RegEx formula you had in there to add a pipe delimiter, correct?
Again, thanks so much! This does exactly what I was hoping for!
i'm glad I could help. Yes, the starting point was the Regex that replaced all occurrences of 2 spaces or more with a pipe. specifying at least 2 spaces made sure that the workflow left the single spaces that were within the customer name.
Judging from your screen name, do you work in the Energy sector? I happen to work for a renewable energy provider and most of our power comes from hydro.
I don't specifically work in the Energy sector, however I have had multiple client projects in that realm. Hydro power has certainly been a fast growing energy power within the last few years from what I've seen at clients!