Hi ,
I'm trying to find the position or string based on STRING function in AMDP Method using SQL below Statements.
select locate( lv_text_as, ' ' ) INTO lv_len FROM dummy;
select substr( lv_text_as, 1, lv_len ) from dummy;
SELECT substr( lv_text_as, lv_len, length( lv_text_as ) - lv_len ) from dummy;
----------------------------------------------------------------------------------------------------------------
select substr_before( lv_text_as, ' ' ) INTO lv_text_bs from dummy;
SELECT substr_after( lv_text_as, ' ' ) INTO lv_text_as from dummy;
----------------------------------------------------------------------------------------------------------------
lv_len = locate( lv_text_as, ' ' );
lv_text_bs = substr( lv_text_as, 1, lv_len );
lv_text_as = substr( lv_text_as, lv_len, length( lv_text_as ) - lv_len );
None of the above statements is working due to SPACE as delimiter.
Could you please help me to solve the above issue.
Regards,
Ramana.