Parse a large paragraph of text to store some fields in a database as a list

Need help
1

Hi, I am using an API to get a large paragraph of text, which is a value of one JSON key. I would like to parse this text and store the pieces into different fields in a database table.

Eg. The below items are returns as a one value. I would like to parse this value to store the plant name in one field, zone in another and growth cycle (Annual) in another field. The return response of this key is of type text.

  1. Zinnia (Zone: 3-10, Annual)
  2. Dwarf Zinnia (Zone: 3-10, Annual)
  3. Giant Zinnia (Zone: 3-10, Annual)
  4. Mexican Zinnia (Zone: 9-11, Annual)
  5. Profusion Zinnia (Zone: 3-10, Annual)
  6. Queen Zinnia (Zone: 3-10, Annual)
  7. Scarlet Zinnia (Zone: 3-10, Annual)
  8. Thumbelina Zinnia (Zone: 3-10, Annual)
  9. White Zinnia (Zone: 3-10, Annual)
  10. Zinnia Elegans (Zone: 3-10, Annual)

How do I accomplish this?

2

yes did you figure it out?

3

This topic was automatically closed after 70 days. New replies are no longer allowed.