How can I truncate a data stream like the one value?
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 one value?
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!
Create a query based on the table with your data and add a calculated field with the following expression:
Result: Left([YourFieldName],InStr(1,[YourFieldName],"s")-1)
Replace "YourFieldName" with the name of your field.
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
I see that you have asked this same question again in another thread.
Will you be starting any more threads, with the same question, that we can waste our time with?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick