- last edited on by
MaciejNeumann
Hi all,
maybe it's a stupid question but, is there an easy way to export the data from a multi-analysis view to excel?
I want these data in Excel:
Regards, Josep Maria
@jcamps I might have a solution to this, but I don't like it myself 😄
Let's assume you have Notepad++ [we will use this knowledge kindly provided by the internet https://stackoverflow.com/questions/45969411/notepad-rows-to-columns-in-groups]
Let's say that you ctrl+C, from the word "Dimensions" on the screen you shared to the bottom of the page:
Let's say that you ctrl+V the copy content in a notepad++ page. Here you manually remove the line where you find "Actions":
Now, while on notepad++, blindly press ctrl+H (Find and Replace) and insert the following:
- Find what: (?:[^\r\n]+\R){3}
- Replace with: $0\n
and click on "replace all" > this will add a white line after each group of 3 line.
and now proceed again by filling the "find and replace" form with those value:
- Find what: (\R)(?!\R)|(\R\R)
- Replace with: (?1|:\n)
and press on "replace all" > this will separate your data correctly in column divided by |
The end result will look like this:
Now your data look good enough to be in an excel sheet (where you can use this function to divide the data into columns); for example:
Wrapping up: this solution is horrible but is also why it kinda make me smile 🙂 it's not the easy way, but it gets the data into our beloved excel.
Regards!
Featured Posts
