Examples of the use of the Simple expression generator
PAF429
Posts: 4 New member
I am a newbie.
Interest in using a simple expression generator to use "data from other columns in the table".
Prefix of a specific column value needs to consist of x number of characters from a column within the same row.
Is it possible using a simple expression generator?
Are their example that demonstrate the ability of a simple expression generator to use "data from other column in the table"?
Interest in using a simple expression generator to use "data from other columns in the table".
Prefix of a specific column value needs to consist of x number of characters from a column within the same row.
Is it possible using a simple expression generator?
Are their example that demonstrate the ability of a simple expression generator to use "data from other column in the table"?
Tagged:
Comments
For instance, if you have a column called MyColumn and it had a value abcdefg, the simple expression MyColumn[2:5] would return cde.
Have a look at this Stack Overflow post for more information about string slicing - http://stackoverflow.com/questions/509211/explain-pythons-slice-notation
I hope this helps.
Redgate Software