Question

adding extra column to the database

0

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: https://www.bbc.co.uk/news/uk-scotland-highlands-islands-52791001 I need to have the final 8 digits (52791001) in a column. Thanks in advance

asked 2020-05-24

maryam ghanb

1 answers

Tim v Steenbergen · Accepted Answer · 2020-05-24

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.