AnsweredAssumed Answered

Extracting fields from a text block

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

Title

Extracting fields from a text block

Post

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

Interests: 

- 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.

Thanks!

Nicole

Outcomes