Hi all,
silly question, but I have a column of numbers. I would like to extract the first two numbers from the number string. e.g 997, result 99. The column type is numeric. How do I do this? Thanks!
JC
Solved! Go to Solution.
So the easiest way to do this in one formula is to use TOSTRING and TONUMBER to convert it to a string, get the left characters, and then get the number value back.
Here's an example (replace [yourfield] with your field)
TONUMBER(LEFT(TOSTRING([yourfield]),2))
You can use this formula:
TrimLeft(ToString([Field1]),"2")
Thanks Claje!
I was trying a combination of these and obviously did not have the right combination. I really appreciate this solution!!
VR
JC
Thanks @Bahouth12,
I had thought about running the conversion. This is a great solution and will be trying it out. Thanks for the example too.
VR
JC