Skip to main content

Retrieve all records from the ZapierTable that meet certain criteria.(Find Records (Output as Line Items)

The data is then converted to a csv file with a header and a line feed for each record.
However, some items contain commas in the text.


If there are more than two records in Find Records, the data cannot be extracted correctly

because each data is comma delimited.

 

Can I change the delimiter in Find Records?

Hi @Murinhardt 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode.

Which app is being used to create the CSV?


Hi, @Troy Tessalone 

This is the entire Zap.
The csv is created with the Create file function in AWS S3.

 

 

I am having trouble with the process of adding the header and setting the delimiter of all items to | here.
If there are more than two rows in Findrecords, each item will have a comma, but the data may contain a comma.

 

 


@Murinhardt 

Use this Zap action before the Code step: Formatter > Utilities > Line Items to Text

Then use the Code step to parse the text into the desired data points.

Guide for the general approach:

 


Hi there, @Murinhardt 👋

Just wanted to ask how you got on with the Troy’s suggestion here, did that approach do the trick?

Please let us know whether you need any further assistance at all, keen to make sure you’re all set! 🙂