Problem : I have a column of cells with variable date ranges:
1907-1913
1910-1911
1908-1911
etc.
The cells have to be converted to:
1907; 1908; 1909; 1910; 1911; 1912; 1913
1910; 1911
1908; 1909; 1910; 1911
etc.
Open Refine can be used to convert this. Using add column based on this column, you would use the following GREL command:
forRange(toNumber(substring(value, 0,4)), toNumber(substring(value, 5,9)) + 1, 1, currentYear, currentYear).join("; ")
Yes, it looks daunting. But let's break it down, starting with the forRange command:
Showing posts with label loops. Show all posts
Showing posts with label loops. Show all posts
Monday, July 3, 2017
Subscribe to:
Posts (Atom)