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?
+14Hi
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,
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.
+14Use 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:
+11Hi there,
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! 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
