Skip to main content
Participating Frequently
March 14, 2007
Question

filter column on word length

  • March 14, 2007
  • 4 replies
  • 960 views
How hard can it be??

I just need to filter out a column, that column has text inside, i need to filter the words in that text out, on length and description...

Who got a example code?
This topic has been closed for replies.

4 replies

mo280379Author
Participating Frequently
March 20, 2007
that's just perfect :) i really gt to go in more practice with these kind of looping etc technics

Thanks again
mo280379Author
Participating Frequently
March 17, 2007
hi thanks for your answers for some reason i dind't see any notification mail, yes it's a hard question, seems the never ending story on my side, all the things i want are likely non standard......

I think i need something that just does:

first put the text query in a dilimited string so that the words kan be output like seperate items

then loop the items or search and replace the string: delete where item len gte then 5

that is in simple and non correct code, any idea how to construct it?? i hinkn i'm searching so long now that i really dont see any clue at all anymore....
mo280379Author
Participating Frequently
March 17, 2007
Ok, my Co(n)ldfusion and tears where even bigger when i did my Coldfusion mx7 developer exam and i had a score of 54% :(

Guess i have to work on my practics huh :)

For this above question i found the first start that wll help me out with the rest, see atached code.....

This will put the text column from the query in arrays so that i can individually handle the words in the text

The rest is a simple find and replace workout, thank you!
Inspiring
March 14, 2007
quote:

Originally posted by: mo280379
How hard can it be??

I just need to filter out a column, that column has text inside, i need to filter the words in that text out, on length and description...
Who got a example code?

Exceptionally hard.

There was almost an identical question a couple of days ago and none of us were able come up with an answer. And there are some rather clever people answering questions here.
Inspiring
March 14, 2007
what's your filter logic? which words do you want to filter out?
--

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com