We can use the method translate() which returns a copy of the string in which all characters have been translated using table (constructed with the maketrans() function in the string module), optionally deleting all characters found in the string deletechars. examplefrom string import maketrans # Required to call maketrans function. ... Read More
String class has a method called swapcase() for swapping case of all letters. You can use it as follows:>>> 'Hello World 123'.swapcase()
'hELLO wORLD 123'
>>> 'Make America Great Again'.swapcase()
'mAKE aMERICA gREAT aGAIN'
First of all, the example you gave has different description for a fund. So, you should know which one to be kept. If you want to keep any description, you can use the below query using aggregation functionsSELECT X1."FundName" , min( X0."Dscription") , X0."FundId" FROM INV1 X0 ... Read More
As far as I know, there is no direct way of inserting an Array using SQL query. You will first have to combine the columns (EMPL_Id + Skill Id) using the code and then do a bulk insert to the database.
You need to go to SE93 and input your Transaction code. It will display program name behind your transaction code. You can edit the programs using SE80 and SE38. Below shows Transaction code: SE93 Following shows Transaction Code SE80 to edit an ABAP program by opening ABAP Development workbench: ... Read More
It is possible that the older version of SAP B1 may not show you all the fields of all the forms. If you have the latest version, you should be able to see the data sources that are mapped to given field. You need to open the forms in SAP ... Read More
We can use the method rstrip() which returns a copy of the string in which all specified chars have been stripped from the end of the string. The default char to be trimmed is whitespace. For example:>>> ' Hello '.rstrip() ' Hello' >>> 'Ninja Turtles the movie ... Read More