EDIT

    public static final String DATA_TYPE_LEG_100 = "iapt-type-leg-100.xls";

    public static final String DATA_FILE = DATA_TYPE_LEG_100;   

import eu.etaxonomy.cdm.model.agent.Person;

import eu.etaxonomy.cdm.model.agent.TeamOrPersonBase;

    private static final Pattern[] datePatterns = new Pattern[]{

            Pattern.compile("^(?<monthName>\\p{L}+\\.?),?\\s?(?<year>(?:1[7,8,9])?[0-9]{2})$"), // April 99 or April, 1999 or Apr. 12

            Pattern.compile("^(?<day>[0-9]{1,2})([\\.\\-/])(\\s?)(?<month>[0-1]?[0-9])\\2\\3(?<year>(?:1[7,8,9])?[0-9]{2})$"), // full date like 12.04.1969 or 12. 04. 1969 or 12/04/1969 or 12-04-1969

            Pattern.compile("^(?:(?<day>[0-9]{1,2})(?:\\sde)\\s)(?<monthName>\\p{L}+)\\sde\\s(?<year>(?:1[7,8,9])?[0-9]{2})$"), // full and partial date like 12 de Enero de 1999 or Enero de 1999

            Pattern.compile("^(?<month>[IVX]{1,2})([\\.\\-/])(?<year>(?:1[7,8,9])?[0-9]{2})$"), // partial date like VI-1969

            Pattern.compile("^(?<day>[0-9]{1,2})(?:[\\./]|th|rd|st)?\\s(?<monthName>\\p{L}+\\.?),?\\s?(?<year>(?:1[7,8,9])?[0-9]{2})$"), // full date like 12. April 1969 or april 1999 or 22 Dec.1999

    private static final Pattern typeSplitPattern =  Pattern.compile("^(?:\"*[Tt]ype: (?<fieldUnit>.*?))(?:[Hh]olotype:(?<holotype>.*?)\\.?)?(?:[Ii]sotype[^:]*:(?<isotype>.*)\\.?)?\\.?$");

    private static final Pattern collectorPattern =  Pattern.compile(".*?\\(leg\\.\\s+([^\\)]*)\\)|.*?\\sleg\\.\\s+(.*?)\\.?$");

    private static final Pattern collectionDataPattern =  Pattern.compile("^(?<collector>[^,]*),\\s?(?<detail>.*?)\\.?$");

    private static final Pattern collectorsNumber =  Pattern.compile("^([nN]o\\.\\s.*)$");

            Pattern.compile("^(?:Coll\\.\\s(?<subCollection>[^\\.,;]*)(.))(?<institute>.*?)(?<accNumber>Praep\\..*)?$"), // like Coll. Lange-Bertalot, Bot. Inst., Univ. Frankfurt/Main, Germany Praep. Neukaledonien OTL 62

        fieldUnit, holotype, isotype;

                pupDate = parseDate(regNumber, nomRefPupDate);

                } else {

                    logger.warn(csvReportLine(regNumber, "Pub date", nomRefPupDate, "in", nomRefStr, "not parsable"));

            makeTypeData(typeStr, taxonName, regNumber, state);

    private void makeTypeData(String typeStr, BotanicalName taxonName, String regNumber, SimpleExcelTaxonImportState<CONFIG> state) {

            String fieldUnitStr = m.group(TypesName.fieldUnit.name());

            // boolean isFieldUnit = typeStr.matches(".*([°']|\\d+\\s?m\\s|\\d+\\s?km\\s).*"); // check for location or unit m, km // makes no sense!!!!

            FieldUnit fieldUnit = parseFieldUnit(fieldUnitStr, regNumber, state);

            if(fieldUnit == null) {

                // create a field unit with only a titleCache using the fieldUnitStr substring

                fieldUnit = FieldUnit.NewInstance();

                fieldUnit.setTitleCache(fieldUnitStr, true);

                getOccurrenceService().save(fieldUnit);

            getOccurrenceService().save(fieldUnit);

            // all others ..

            addSpecimenTypes(taxonName, fieldUnit, m.group(TypesName.holotype.name()), TypesName.holotype, false, regNumber);

            addSpecimenTypes(taxonName, fieldUnit, m.group(TypesName.isotype.name()), TypesName.isotype, true, regNumber);

        } else {

            // create a field unit with only a titleCache using the full typeStr

            FieldUnit fieldUnit = FieldUnit.NewInstance();

            fieldUnit.setTitleCache(typeStr, true);

            getOccurrenceService().save(fieldUnit);

            logger.warn(csvReportLine(regNumber, "Type field can not be parsed", typeStr));

    /**

     * Currently only parses the collector, fieldNumber and the collection date.

     *

     * @param fieldUnitStr

     * @param regNumber

     * @param state

     * @return null if the fieldUnitStr could not be parsed

     */

    private FieldUnit parseFieldUnit(String fieldUnitStr, String regNumber, SimpleExcelTaxonImportState<CONFIG> state) {

        FieldUnit fieldUnit = null;

        Matcher m1 = collectorPattern.matcher(fieldUnitStr);

        if(m1.matches()){

            String collectionData = m1.group(1); // like (leg. Metzeltin, 30. 9. 1996)

            if(collectionData == null){

                collectionData = m1.group(2); // like leg. Metzeltin, 30. 9. 1996

            }

            if(collectionData == null){

                return null;

            }

            String collectorStr = null;

            String detailStr = null;

            Partial date = null;

            String fieldNumber = null;

            Matcher m2 = collectionDataPattern.matcher(collectionData);

            if(m2.matches()){

                collectorStr = m2.group("collector");

                detailStr = m2.group("detail");

                // Try to make sense of the detailStr

                if(detailStr != null){

                    detailStr = detailStr.trim();

                    // 1. try to parse as date

                    date = parseDate(regNumber, detailStr);

                    if(date == null){

                        // 2. try to parse as number

                        if(collectorsNumber.matcher(detailStr).matches()){

                            fieldNumber = detailStr;

                        }

                    }

                }

                if(date == null && fieldNumber == null){

                    // detailed parsing not possible, so need fo fallback

                    collectorStr = collectionData;

                }

            }

            if(collectorStr != null) {

                fieldUnit = FieldUnit.NewInstance();

                GatheringEvent ge = GatheringEvent.NewInstance();

                TeamOrPersonBase agent =  state.getAgentBase(collectorStr);

                if(agent == null) {

                    agent = Person.NewTitledInstance(collectorStr);

                    getAgentService().save(agent);

                    state.putAgentBase(collectorStr, agent);

                }

                ge.setCollector(agent);

                if(date != null){

                    ge.setGatheringDate(date);

                }

                getEventBaseService().save(ge);

                fieldUnit.setGatheringEvent(ge);

                if(fieldNumber != null) {

                    fieldUnit.setFieldNumber(fieldNumber);

                }

                getOccurrenceService().save(fieldUnit);

            }

        }

        return fieldUnit;

    }

    private Partial parseDate(String regNumber, String dateStr) {

        String day = null;

        String month = null;

        String monthName = null;

        String year = null;

        for(Pattern p : datePatterns){

            Matcher m2 = p.matcher(dateStr);

                    year = m2.group("year");

                    month = m2.group("month");

                    monthName = m2.group("monthName");

                    month = monthFromName(monthName, regNumber);

                    if(month == null){

                    day = m2.group("day");

                if(year != null){

                    if (year.length() == 2) {

                        // it is an abbreviated year from the 19** years

                        year = "19" + year;

                    }

                    break;

                } else {

        if(year == null){

            values.add(Integer.parseInt(year));

            if (month != null) {

                values.add(Integer.parseInt(month));

            if (day != null) {

                values.add(Integer.parseInt(day));

                        // match group colCode not found

                    if(collectionCode == null && instituteStr == null){

                        logger.warn(csvReportLine(regNumber, "neither 'collectionCode' nor 'institute' found in ", text));

                        continue;

                    }

            logger.warn(csvReportLine(regNumber, "Could not parse specimen fieldUnit", typeName.name().toString(), text));

        if(accessionNumber != null){

            facade.setAccessionNumber(accessionNumber);

        }