I have a requirement where I have to fetch data based on text. The text has values in upper/lower/mixed etc.
I am getting the values if it is in propercase(EX: John Milton) or Capitals(JOHN MILTON) but I am not fetching data if
a word in that text is separated by '.'. (EX: John MIlton W.s.). My requirement is if they are separated by special characters
then all the letters should be in capital.
IT_TXTS TYPE TABLE OF STRING, "Tabel for data storing
WA_TXTS(100) TYPE C, "Getting each words
CP_TEXT TYPE STRING, "Copying text
NN_TEXT TYPE STRING. "Result text
CP_TEXT = STRING1.
SPLIT CP_TEXT AT SPACE INTO: TABLE IT_TXTS.
LOOP AT IT_TXTS INTO WA_TXTS.
translate wa_txts to lower case.
translate wa_txts+0(1) to UPPER case.
CONCATENATE NN_TEXT WA_TXTS INTO NN_TEXT SEPARATED BY SPACE.
Please modify my code to get the require result.
Thanks in advance,