• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

How do I take each output record from the Iterator and put them on a new line (so I get one text with a record on each line)?

Status
Not open for further replies.

Fagun Shah

Well-known member
Instead of using Iterator use Data Transformer -> Line Itemizer which will give you comma separated values for each item in the array.

Then you can use Text Formatter -> Replace Text to replace comma with /n for new line.
 

apps

Member
Hi Fagun,

Thanks, appreciate you help. I already tried that (actually from reading another of your posts here).

It solved the first problem by getting all data in one text field, however the issue is that the data in the process gets mangled up. From my iterator I get two output of time entries for my time logging:
1. Task title A, start time A, end time A
2. Task title B, start time B, end time B

Using Line Itemizer I get one text yes, however it mixes them together which make them unusable. I get 3 lines:
1. Task title A, Task title B
2. Start time A, Start time B
3. End time A, End time B

And replacing comma with new lines get's me:
Task title A
Task title B
Start time A
Start time B
End time A
End time B

Either way the start and end times are separated from the task they belong to.

Want I need returned to use the data is simply two lines:
1. Task title A, start time A, end time A
2. Task title B, start time B, end time B

I hope it makes sense. I would imagine this would be simple, but I can't just figure out how to get this result.
 
P

Pabblymember11

Guest
Hi Fagun,

Thanks, appreciate you help. I already tried that (actually from reading another of your posts here).

It solved the first problem by getting all data in one text field, however the issue is that the data in the process gets mangled up. From my iterator I get two output of time entries for my time logging:
1. Task title A, start time A, end time A
2. Task title B, start time B, end time B

Using Line Itemizer I get one text yes, however it mixes them together which make them unusable. I get 3 lines:
1. Task title A, Task title B
2. Start time A, Start time B
3. End time A, End time B

And replacing comma with new lines get's me:
Task title A
Task title B
Start time A
Start time B
End time A
End time B

Either way the start and end times are separated from the task they belong to.

Want I need returned to use the data is simply two lines:
1. Task title A, start time A, end time A
2. Task title B, start time B, end time B

I hope it makes sense. I would imagine this would be simple, but I can't just figure out how to get this result.

We checked upon you concerning use case and it doest seems possible.
 

apps

Member
Sorry to hear. Would it be possible to add a an action similar to the Line Itemizer that does this (or maybe an option in the Line Itemizer)?

Because it seems to be the exact same kind of action and quick option to add because only the way it OUTPUTS the data should be slighty tweaked. It should still split the items in the same way, but instead of putting all the properties of the SAME type together on the same line, it would put the DIFFERENT properties in the same line.

Having this would enable you to create a text by concatenate all of the records from a response which would enable many use cases. Basically creating emails, composing documents, summarizing data and much much more etc.
 
Status
Not open for further replies.
Top