I have a simple column with the file name, [Name]. Within our file name we include a revision, always worded "Rev0X" where X is next appropriate number.
So sample file name would be "C081-02-003 - Rev01 - Document Title"
I am looking to create a custom column that extracts the Rev number, but do not know where to start with a formula.
Essentially the new column, based on above sample file name, would return "01" but would be capable of adapting based on documents that could have any Rev number from 00 to 99.