Get multiple texts after Splitting and concatenating
Example
8x2.6x0.9 is the size data in inches. Convert it to the size data in centimeters. The results are as follows:
20.32x6.60x2.29cm
Write the SPL script:
A |
|
1 |
8x2.6x0.9 |
2 |
=A1.split@p("x").(string(~*2.54,"#.00")).concat("x")+"cm" |
A1 Size data in inches
A2 The split function splits the text into a sequence according to the delimiter x, @p means the data type is automatically parsed, the data in the numerical sequence is converted into centimeter data, the converted data is converted into text, and two decimal places are reserved, and then the sequence Use the function concat to concatenating a text according to the separator x, and finally concatenate "cm"
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL
Chinese version