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 »
You may come across the situation, where you want to extract the substring from a given string. Sage X3 has a special function to extract substring from given String. New Stuff: How to filter the table with user defined conditions in Sage X3 seg$: This function is used to extract a sub-string located between two positions… Read More »
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 »