topic READ_TEXt in Application Development and Automation Discussions

READ_TEXt

Former Member — Wed, 26 Nov 2014 12:15:02 GMT

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

Re: READ_TEXt

Former Member — Wed, 26 Nov 2014 12:26:16 GMT

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

Re: READ_TEXt

Former Member — Wed, 26 Nov 2014 12:31:00 GMT

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

Re: READ_TEXt

RaymondGiuseppi — Wed, 26 Nov 2014 12:40:40 GMT

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

Re: READ_TEXt

Former Member — Wed, 26 Nov 2014 13:20:07 GMT

Hi All,

Solved with the help of FM S'WA_STRING_SPLIT'.

Thanks and Regards,

Uma