An action to get rows from a text file (CSV) would be handy.
We have a "Create CSV Table" action from an array, but no actions to load, read, transform CSV data which many enterprises processes still requires.
Actually, why not using the SAME powerful "Edit SQL data with Power Query" and create a new tool called "Edit CSV with Power Query"? I'm going to create a new idea...
Does anyone know how many 'votes' an idea has to get before it gets noticed and addressed (even if it's denied)?
Great idea, but why limit to "CSV"? Just have it be a "text extract" action with a specifiable delimiter, maybe even make it a 1-10 character string, just in case of weird legacy formats. Also, use whitespace as delimiter, and now you get "all the words". Also allow just grabbing the whole line with no delimiter.
You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.
Yes, I need this, and from reading here, many many people do. The idea is 2 1/2 years old and I don't see a response. Very disappointing.
For me, I would need two things:
1. A simple record count for a csv file
2. A way to get a record count based on a filter, such as counting error records by testing field x for a value.