export const RANGE_KEY = ':';
export const SELECT_KEY = ',';

export const isSelect = (formula: string) => {
    if (formula.includes(RANGE_KEY) && formula.includes(SELECT_KEY)) return false;
    return formula.includes(SELECT_KEY);
};

export const getSelectField = (formula: string): string[] => {
    return formula.split(SELECT_KEY);
};

export const getRangeField = (formula: string, fieldsWithIndex: string[]): string[] => {
    const [startField, endField] = formula.split(RANGE_KEY);
    const startIndex = fieldsWithIndex.indexOf(startField);
    const endIndex = fieldsWithIndex.indexOf(endField);
    return fieldsWithIndex.slice(startIndex, endIndex);
};

export const isRnage = (formula: string) => {
    if (formula.includes(RANGE_KEY) && formula.includes(SELECT_KEY)) return false;
    return formula.includes(RANGE_KEY);
};