11-26-2014 12:15 PM
Hi All,
I am getting data from FM read_text out put as tdline table with 132 characters field.This need to pass to BI system as 300 characters into BI System.Can any one provide logic to pass as 300 characters into BI system.
Thanks and regards,
Uma
11-26-2014 12:26 PM
Hi,
convert your tdline table into a string (with a loop or a function module like SCMS_FTEXT_TO_STRING) and move this string to a field of domain text300.
Regards,
Klaus
11-26-2014 12:26 PM
Hi,
convert your tdline table into a string (with a loop or a function module like SCMS_FTEXT_TO_STRING) and move this string to a field of domain text300.
Regards,
Klaus
11-26-2014 1:20 PM
Hi All,
Solved with the help of FM S'WA_STRING_SPLIT'.
Thanks and Regards,
Uma
11-26-2014 12:31 PM
Hi Uma,
I suggest you to concatenate all lines from FM READ_TEXT output into a string and split it using FM SALP_POP_SPLIT_TEXT, filling parameter "OUT_LINE_LENGTH" with 300 (characters).
Best regards,
Alexandre B. Dambrowski
11-26-2014 12:40 PM
It should be easy to concatenate lines returned by READ_TEXT until length of the string get greater than 300 or no more lines and then truncate.
But, using READ_TEXT for big volumn of data may generate performance problem, so you may be required to replace those READ_TEXT by SELECT from STXL and some IMPORT FROM INTERNAL TABLE (Read Alternative to READ_TEXT Function Module (No more FM needed) and original thread Mass reading standard texts (STXH, STXL)
Regards,
Raymond