Count the number of words in a field

In this command, the number of words in the Address field will be tabulated in a field named countadd:

ALTER TABLE ALIAS() ADD COLUMN countadd C(10) REPLACE ALL countadd WITH TRANSFORM(WORDS(address))

ALTER TABLE ALIAS() ADD COLUMN countadd C(10)

REPLACE ALL countadd WITH TRANSFORM(WORDS(address))

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

Thank you for providing such a powerful product! I am so glad I renewed in at the 3-year level. I am amazed at what a difference the ANKlink makes on cleaning client databases.

C.S., Sequim, WA