How to parse delimted feild in FileMaker Pro into a new table?

One way would be to write a script that splits the text into lines (using GetValue() ), then splits each line by semicolon ( Substitute( $line, ";", "¶" ) then GetValue() from the resulting list), and finally posts the data into the other table (Go to Layout, New Record, Set Field). Can sketch the whole script, if you want I'd write it like that: Go to Layout( My Table ) Go to Record/Request/Page First # Loop over records Loop Set Variable $line, 1 # Loop over lines Loop Exit Loop If ValueCount( My Table::My Field ).

One way would be to write a script that splits the text into lines (using GetValue()), then splits each line by semicolon (Substitute( $line, ";", "¶" ), then GetValue() from the resulting list), and finally posts the data into the other table (Go to Layout, New Record, Set Field). Can sketch the whole script, if you want. I'd write it like that: Go to Layout( My Table ) Go to Record/Request/Page First # Loop over records Loop Set Variable $line, 1 # Loop over lines Loop Exit Loop If ValueCount( My Table::My Field ).

I think that should get me going in the right direction – mcgrailm Nov 2 '10 at 13:44 ok so in my script I it do a find replace changing ";" to "¶" which makes paragraphs and use GetValue ( listOfValues ; valueNumber ) so listOfValues would = my modified field how do I keep track or loop through the paragraphs – mcgrailm Nov 2 '10 at 14:01 Added an example script to the post. – Mikhail Edoshin Nov 2 '10 at 18:32 awesome thank you – mcgrailm Nov 2 '10 at 19:34.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.