I'm trying to build a Query using Oracle (10g) to identify all fields with a roman numeral - and put that roman numeral in a new cell:
Field Roman Numeral
MGM XXIX: XXIX
MGM XIX, One XIX
Roman Numerals are limited to I, V, X, L, C, D, M
I haven't found a function for this but...
I'm thinking that the query may be written where a word within a field contains (V, X, L, C, D, M) only - but will need to account for roman numerals like 'VI' -- where there is an I. Also, I think including the 'I' will result in words as 'DIM', 'MID', 'LID' - not what I would want. So - would need to search for I, II, III, IV separately.
Roman Numerals won't appear in the first part of a piece of text... and they may be proceeded by a comma (MGM XIX, one)
Thanks in advance