Excel – henrydaiit

Find out the last position of a character in string from right to left

May 30, 2019May 30, 2019 admin 0 Comments Excel, Find, LEN, position of a character in string, SUBSTITUTE

EG: find out the last position of character ‘_’ in text in cell A1 =FIND(“|”,SUBSTITUTE(A1,”_”,”|”,LEN(A1)-LEN(SUBSTITUTE(A1,”_”,””))))

SAP ABAP

ABAP 7.5 declare a new field in SELECT statement by CAST

December 24, 2022 admin 0

Sample: SELECT vbak~vbeln, vbak~kunnr, vbak~vdatu, vbap~matnr, vbap~wrf_charstc1, vbap~vstel, vbap~werks, vbap~kwmeng, mara~satnr, CAST( ‘ ‘ AS CHAR( 70 ) ) AS atwrt INTO TABLE @DATA(lt_so) FROM vbap INNER JOIN vbak ON vbap~vbeln = vbak~vbeln INNER JOIN mara ON vbap~matnr = mara~matnr WHERE vbak~auart IN ( ‘ZGW1’,‘ZGW2’ ) AND vbak~autlf = ” AND vbap~werks IN @lt_r_werks AND vbap~matnr IN @lt_r_matnr

Uncategorized

tmp

November 30, 2022 admin 0

M	T	W	T	F	S	S
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28