Hello everybody!
Could you please assist me?
I've got a field which contains 1 or 2 words.
I would like to get the following:
- If there's 1 word, the first 3 letters (its already ok with Left function)
- if there are 2 words, the first 2 letters from the first word and the 1st from the second (ex. Costas Kostas -> CoK). :banghead:
Any ideas?
Thank you in advance!
Regards,
Costas
Could you please assist me?
I've got a field which contains 1 or 2 words.
I would like to get the following:
- If there's 1 word, the first 3 letters (its already ok with Left function)
- if there are 2 words, the first 2 letters from the first word and the 1st from the second (ex. Costas Kostas -> CoK). :banghead:
Any ideas?
Thank you in advance!
Regards,
Costas