Hello! I need help extracting numbers from a text field that contains both text and numbers.
The numbers must then be summed in a new column. I've tried using calylate field but can't get this to work.
Below are some examples of a text string.
[{"lamningstyp":"Kolningsanläggning","antal":1,"egenskap":"Typ: Kolbotten liggmila, Form: Rektangulär"},{"lamningstyp":"Husgrund, historisk tid","antal":3,"egenskap":"Verksamhet: Industri"},{"lamningstyp":"Träindustri","antal":1,"egenskap":"Verksamhet: Såg/Sågverk"},{"lamningstyp":"Kvarn","antal":1,"egenskap":"Typ: Hjulkvarn"},{"lamningstyp":"Brott/täkt","antal":1,"egenskap":"Material: Lera"}][{"lamningstyp":"Fångstgrop","antal":4,"egenskap":"Bytesdjur: Älg/ren, Form: Rund"},{"lamningstyp":"Fångstgrop","antal":6,"egenskap":"Bytesdjur: Älg/ren, Form: Oval"}]:
