Length conversion

[Vaku1606]

Hello team,

I have 2 formats for length coming from 2 different sources/tables: for example 146.0 and 146 mm. How can I convert 146 mm into 146.0 in order to have the same format and standardization in place?

Thanks in advance and regards

[sidhiq91 · Accepted solution]

@Vaku1606  Please use below expression to get the Length in the desired format. If it resolves your issue like and accept it as your solution.

NoConcatenate
Temp:
Load
Num(Keepchar(Length,'0123456789'),'#,##0.0') as Length;

Load * Inline [
Length
146 mm
];

Exit Script;

[Vaku1606]

Thanks a lot, works perfectly