Parsing source doc rows as well as columns

jammdou

When using a CSV source and coverting to Google Sheets is there a way to parse individual rows in the source CSV so that the resulting sheet will only display the desired rows from there going forward in subsequent conversions? All I see is the ability to parse columns.

Karoline from Sheetgo

jammdou Hi J,

Please could you give an example of what you are trying to achieve?

jammdou

Karoline from Sheetgo Hi and thanks for the reply. I wish to edit a csv file that I download from an application which arrives with some columns AND rows that I do not wish to keep in the edited file. I want to parse specific columns AND rows of data. Parsing out the columns using standard Sheetgo ability is straightforward. What I am looking for is a way to parse out several of the rows of data from the original as well as the parsed columns. My research thus far shows that I will likely want to use SQL language for this but I have not yet found an SQL command (statement) that allows me to define row numbers to parse.

I appreciate your help and look forward to your reply.

Sneha_Roy1806

@jammdou Hey J,
You might find it helpful to use the Sheetgo SQL feature.

LIMIT x: Specifies the number of rows to return.
OFFSET y: Skips the first y rows.

****Feel free to reach out if you have any further questions or suggestions you’re looking to explore.

LauraKlein

I have a similar question. I would like to convert CSV data into a PDF report. My columns are:
Sample | Test Result | Test Requested | Customer Name | Order Number

Each row will have a different sample/result for a given customer and order number. I want to send the sample results to each client associated with an order number, but I don’t know how to code my template document. Can you please give me some direction?