How can I truncate a data stream like the values below?
total cutting time: 151.2s §MES,1015
total cutting time: 90.2s §MES,1015
I want to extract the seconds value, like I want to see:
151.2
90.2
Thanks for the help in advance!
How can I truncate a data stream like the values below?
total cutting time: 151.2s §MES,1015
total cutting time: 90.2s §MES,1015
I want to extract the seconds value, like I want to see:
151.2
90.2
Thanks for the help in advance!
Hi There
In a query you can use the following:-
Expr1: Left([String],InStr(1,[String],"s")-1)
Where String is the name of your Field in the Table
that clean up a lot but came back as
total cutting time: 90.2
I will like to display just the number as 90.2
Anything else I can do?
Thanks!!!!
I tried a mid string like the one below...
Expr1: Mid([String],21,5)
how ever I will get the "s" on the 90.2
151.2
90.2s
Hi
So you get this in the query result: total cutting time: 90.2
If you only want to display the 90.2 without any Label then you need to generate a Report based on the query output.
How about Expr1:Trim(Replace(Left([String],InStr(1,[String],"s")-1),"total cutting time: ",""))
Cheers,