20380_en-US

liliconcom

examples of column formula loops<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

Trying to ID 9 character words in column :Trim & Case with the following formula

For( i = 1, i < 20, i++,

If( Word((i, Length( :Name( "Trim & Case" ) ) == 9),

  Word( i, :Name( "Trim & Case" ) ),

  ""

)

)

Re: examples of column formula loops

Works well.   Thanks. Much better than mine

Re: examples of column formula loops

Try this formula:

word_list = Words(:Name("Trim & Case"), " ");

word9s    = "";

for (i = 1, i <= nitems(word_list), i++,

      if (length(word_list[i]) == 9,

            if (word9s == "",

                  word9s = word_list[i];

                  ,

                  word9s = word9s || "," || word_list[i];

            );

      );

);

word9s;