adding extra column to the database

I have a data set of URLs and their relevant titles (in a data grid), but need to extract the final 8 digit of the URLs to match them with another set of data. I usually do it on an Excel file by using ‘split’ function, but I am aiming to get the data automatically, so wondering is there any way in Mendix to have it as a calculated attribute? For example in this URL: I need to have the final 8 digits (52791001) in a column. Thanks in advance
1 answers

That is an option. In the calculation-microflow you can use

substring($yoururl, length($yoururl)-8, 8)

Mind the performance issue of calculated attributes. You can prevent them by storing the calculated attribute in a 1-1 associated helper-object, which causes the calculation to only get performed when the attribute is actually used.