Skip to Content
0
Jul 27, 2016 at 11:57 PM

Problems to split string long

143 Views

Hello, I am trying to split a long string in parts equals for after to insert this information on fields different, for example:

Split to var_textlong and put each result on:

v_text1 that after will be inserted on text1 of my table Z.

v_text2 that after will be inserted on text2 of my table Z.

Etc..
This is like the SAP ERP saves information with a lot of characters in its tables.

I try to making this of the next form but I have problems with the validation, if a valor be passed to split the string, my code broke

v_str = 'A long text.....'

v_value1 = STRLEN( v_str ) / 3.

v_value2 = v_value1 + v_value1.

v_desc1 = v_str(v_value1).

v_desc2 = v_str+v_value1(v_value1).

v_desc3 = v_str+v_value2(v_value1).