Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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 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;
Thanks a lot, works perfectly