How to get first letter of each word in a field

[MikeG]

I am trying to do an update function on a field. The field has multiple words. I am trying to get the first letter of each word, which are not all the same length.
I have created an update function using Substr knowing how many characters between the 1st and 2nd word in some of the records. I don't want to have to keep changing this to update all records by calculating each records character numbers to get the results needed.
Thanks for your help !!!!

[Allen Klimeck]

Re: How to get first letter of each word in a field

try left(word(yourfield.value,1),1) to get the first letter of the first word and left(word(yourfield.value,2),1) to get the first letter of the second word and so on ( I'm on a Linux box so I can't test this ;-)

[MikeG]

Re: How to get first letter of each word in a field

What would be the value???

[Allen Klimeck]

Re: How to get first letter of each word in a field

"yourfield.value" is the data in your table field

[GGandhi]

Re: How to get first letter of each word in a field

if you can write a function

dim txt as c
txt = "they shoot the horses, don't they?"
dim txt2 as c
txt2 = strtran(txt," ",crlf())

for i=1 to *count(txt2)
	traceln(substr(word(txt,i),1,1))
next

substituting txt with the data from your field that should give you the first character of all the words in the field.
there may be better functions available, but this one seems to work.

[GGandhi]

Re: How to get first letter of each word in a field

here is the function

FUNCTION getFirstLetter AS C (txt AS C )
dim txt2 as c
txt2 = strtran(txt," ",crlf())
dim msg as c = ""

for i=1 to *count(txt2)
	msg = msg+substr(word(txt,i),1,1)+" "
next
msgbox("Result", msg)
END FUNCTION

and the usage
https://www.screencast.com/t/tNvVktTfha

edit: incidentally what is your update operation?
most people need the first letter only to make upper case letter in the sentence.

[MikeG]

Re: How to get first letter of each word in a field

Thanks Allen,
That worked for me..
Your help is appreciated.....

[MikeG]

Re: How to get first letter of each word in a field

Thanks for your help Gandhi.. I am not that good at writing code...