9
quizzes
ParseSimple
quizzes_Matched
Formula
REGEX_Replace([_CurrentField_], "\w+_(\d)_\w+", "$1")
Columns
Rows
Warn
Value
ParseComplex
Value
Warn
Name_Matched
Warn
Value
ParseComplex
Value
Warn
Name_Matched
Bin = If tonumber([Name]) > 6 then "3"
ELSEIF tonumber([Name]) > 3 THEN "2"
ELSE...
Sections
1
2
3
4
5
6
7
8
9
Allow
Missing Column Value = IF !Contains([Column Value], [Numbers]) THEN [Numbers]
EL...
Warn
Error
Cross Section = [Row]+[Column]
Cell Value = Substring([Row Value],tonumber(TrimL...
Column = IF [Name] = "X1" THEN "C1,C2,C3"
ELSEIF [Name] = "X2" THEN "C4,C5,C6"
E...
Column
Row
[Cell Value] = "0"
Simple
=
Cell Value
True
fixed
2020-01-31 15:23:17
0
0
2020-01-31 15:23:17
2020-01-31 15:23:17
[Cell Value] = "0"
isnull([Missing Column Value])
or isnull([Missing Row Value])
or isnull([Missing Cross Section Value])
Custom
=
True
fixed
2020-01-31 15:26:22
0
2020-01-31 15:26:22
2020-01-31 15:26:22
isnull([Missing Column Value])
or isnull([Missing Row Value])
or isnull([Missing...
[Count] = 1
Simple
=
Count
True
fixed
2020-01-31 15:47:15
0
1
2020-01-31 15:47:15
2020-01-31 15:47:15
[Count] = 1
Warning
All
ByName
Row - Ascending
Column - Ascending
Contains([quizzes],"0")
Simple
Contains
quizzes
True
fixed
2020-01-31 15:53:46
0
0
2020-01-31 15:53:46
2020-01-31 15:53:46
Contains([quizzes],"0")
Iteration
Output
Input58
530070000600195000098000060800060003400803001700020006060000280000419005000080079
Transposed
9
Formula
REGEX_Replace([_CurrentField_], "\w+_(\d)_\w+", "$1")
Horizontal
Sudoku Solver
Tab
Questions
Tab (55)
MacroOutput
Macro Output (56)
Macro Output (56)
MacroOutput
Macro Output (57)
Macro Output (57)
MacroInput
Macro Input (58)
Macro Input (58)
Macro
Input58
Ignore
AllSame