15.2 Split string - separate by carriage return (CR) - automatic parsing of data type

 

Here is a CR-separated number string. To find the largest number:

imagepng

Script:

=spl("=?1.split@np().max()",A1)

Result: 3

The function split is used to split the string into a sequence; the option @n means splitting by CR (you don’t have to use this option, you can use the parameter "\n” instead); the option @p means automatically parsing the data type, for example, the integer string can be parsed into integers.


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1658971295726
https://c.scudata.com/article/1659058887506