Sage X3 has master screens like Product master, Supplier master, Customer master etc.. where we can save information about object, means in product master we can save data about product, in supplier master we can save information about supplier like wise. So as per the client’s requirement, we have added PAN No field at customer… Read More: Duplicate PAN Number Validation on Customer Master in Sage X3 »
While dealing with strings, we often require certain characters or a substring from given string. Sage X3 provides a special function to extract a substring from provided CLOB or a string. Syntax: mid$(EXP_STRING,EXP_POS,EXP_NB) Where, EXP_STRING is an expression returning a CLOB or string value. EXP_POS is an expression returning an integer value that is the… Read More: How to extract a Substring from a String in Sage… »
In this blog, we are looking the X3 feature for replacing the specific character in the input string. New Stuff: How to open the object managed screen via code? The ctrans function is very helpful if the user wants to replace the substring as same in SQL with the help of REPLACE(). Syntax: ctrans(“inputstring”,”find character”,”replace character”)… Read More: How to replace the character in the string? »
There Is a common scenario in development where we need to find a sub string from a string value. Just to help with the syntax we will be providing the help on the syntax, this is to find a particular value from a series of numerical, alphanumerical or date expressions or variables. New Stuff: How to… Read More: How to Find a Sub String in a String »
