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

Script:

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

Result: 45

The function split is used to split the string into a sequence; the option @c means splitting by comma (you don’t have to use this option, you can use the parameter “,” 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/1658886112190
https://c.scudata.com/article/1658971343051