Extracting fields from a text block
I have the need to upload a structured text block of date to a simple database and then extract the data into individuals fields that could easily be exported into an excel type file. For example I would have a series of text blocks that look like this:
name: Sally Smith
address: 123 main street
And I need to be able to extract that information into individuals fields such as a name field, address field and so on.
I am just not sure what the equation for the name field would look like to tell it to pull the name Sally Smith when it sees the tag "name:" in the text block.