cancel
Showing results for 
Search instead for 
Did you mean: 

Text (CSV) file - get rows

An action to get rows from a text file (CSV) would be handy.

Status: New
Comments
Level: Powered On

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...

Level: Powered On

Does anyone know how many 'votes' an idea has to get before it gets noticed and addressed (even if it's denied)?

Level: Powered On

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.

Super User

Hi!

 

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.

>