refactoring fields - complete with example

[ect123]

to remove an x using an expression, in QGIS regex would be regexp_replace("label",'(X.*$)','')

[ect123]

This would probably be best included on the "creating a virtual layer" page, since removing an x is already mentioned.