15.4 Concatenate into string
The following is the size data in inches.
We want to convert the data to the one in centimeters and write the result to A2:
=spl("=?1.split@p(""x"").(string(~*2.54,""#.00"")).concat(""x"")+""cm""",A1)
Use the function split to split the string into a sequence by the separator x, the option @p means automatically parsing the data type; convert the data in inches in the sequence to the data in centimeters, and convert the converted data to a string sequence and retain two decimal places; use the function concat to concatenate the string sequence into a string with the separator x, and concatenate the centimeter unit “cm”.
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1659058887506
https://c.scudata.com/article/1659154176907
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/