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:
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
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/