RaqForum 19 No.
1 Reply  •  247 View  • 
     ...

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"


 
 •  247 View  •