AnsweredAssumed Answered

Extracting fields from a text block

Question asked by NicoleHartman1367 on Dec 16, 2011
Latest reply on Dec 16, 2011 by philmodjunk


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

city: somwhere

state: MD


- reading

- writing

- swimming


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.