nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

737490_en-US

liliconcom

sumif: count columns if they contain some character

Hello,

I found a discussion from 2015 (subject "sumif") that has a very helpful script for my current task.I wrote there my question but I don't know if people who participated in that discussion can see my question.

This script I found (slightly modified) and it works great for counting columns for each row where values are "0/0" (or whatever).

dt << New Column("Sum",
    Numeric, Formula(
        Local({i = 0, n = N Col(Current Data Table()) - 1},
            Sum(Repeat({i++ ; (Column(i)[] =="0/0")}, n))
        )
    )
);

However, how to edit this script to count columns that Contain "some_character"?

I have attached a data table where the last column "Sum" has a formula and needed resulted numbers.

I have a big data table and would like to have a script for counting columns for each row with specific values (as character).

I tried to modify the script above but it doesn't work:

dt << New Column("Miss",
    Numeric, Formula(
        Local({i = 0, n = N Col(Current Data Table()) - 1},
            Sum(Repeat({i++ ; (Contains(Column(i)[],"."))}, n))
        )
    )
);

</CODE>Please, helpValentina</LINGO-BODY><LINGO-LABS id="lingo-labs-737490" slang="en-US" mode="CREATE"><LINGO-LABEL>Automation and Scripting</LINGO-LABEL></LINGO-LABS><LINGO-SUB id="lingo-sub-737586" slang="en-US" mode="CREATE">Re: sumif: count columns if they contain some character</LINGO-SUB><LINGO-BODY id="lingo-body-737586" slang="en-US" mode="CREATE">The original data table you attached wasn't like that as it has 4 columns (you cannot ignore Sum column) <img src="https://us.v-cdn.net/6038925/uploads/images/62510iAAF3B35AD80E493A/jthi_0-1711103084651.png" role="button" title="jthi_0-1711103084651.png" alt="jthi_0-1711103084651.png" /> Depending on your data, this is how I would do this if I were to use a Formula (most likely I would avoid that and just use a pure script solution) <PRE><CODE class=" language-jsl">Names Default To Here(1); dt = Open("$DOWNLOADS/sum_help_data.jmp"); dt << Delete Column("Sum"); dt << New Column("Miss", Numeric, Continuous, Formula( As Constant( cols_of_interest = Filter Each({colname}, Current Data Table() << Get Column Names("String"), !IsMissing(Regex(colname, "S\d")); ); ); Local({ res = 0; }, For Each({colname}, cols_of_interest, res = res + (Contains(Column(colname)[], ".") > 0); ); res; ); ));