Re: [GENERAL] Using regex to update a table

howardn...@selestial.com wrote: Happy new year everyone! I am trying to create a column to extract the file extension from a column in a table and set another column to this value. E.g. foo.doc -> doc I am using the regex E'\\.([[:alnum:]])*$', but I cannot seem to find the correct update c

[GENERAL] Using regex to update a table

Happy new year everyone! I am trying to create a column to extract the file extension from a column in a table and set another column to this value. E.g. foo.doc -> doc I am using the regex E'\\.([[:alnum:]])*$', but I cannot seem to find the correct update combination. My best attempt to d