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)) |
M.K., Aurora, ILVince [in support] took the time and spent about 2 hours on the phone with me as we walked through an issue and figured out the problem. To me he went above and beyond normal support and really thought outside the box to figure out the solution. Thank you again Vince for all your help.
