Hello,

How can I pull out sentences from a paragraph and put them into separate fields

Thanks.

You will need to provide more information on what you are wanting.

This need comes up all of the time. Do a search for [color:blue]+parse +Text +Field and you will find hundreds of hits.

Lee

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/193588/post/283010/#283010

Hi Lee,

I need a way to extract each sentence into separate fields, for this I will use a loop but how a calculation will know the deference between a word and a sentence, there is no (.) or (,) just text

how a calculation will know the deference between a word and a sentence, there is no (.) or (,) just text

How would YOU know the difference?

BTW, I would wonder about need to put sentences into fields. You meant records, right - a record for each sentence?

Maybe you could manipulate the data prior to importing it. i.e. use a text editor that has Regular Expressions, and Grep Pattern to such as TextWrangle on the Mac or TextPad (I think it is) on Windows.

Lee