I have a 'name' field with composite name; numbers and words e.g. "1237, Café"
I managed extract the part number with Field Calculator and make a new field (see 1) with this expression
left( "Name" , strpos( "Name" ,'\s') - 1)
But I can´t find the way to extract the part names - just words!
If I use this
regexp_replace( "Name" , '\W', ' ')
Creating a new field result only fields with numbers...(see 2)
EDITED: correction; the results with only numbers; if the type is "whole number (integer)"!!
Updating the 'name' field, result the same fields only without ','... e.g. "1234 Café"