Jump to content

getting left values


This topic is 7238 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi i want to extract a number before a "_" eg 1_, 2_, 22_

using the left function only gives me the first number not the double digit.

where do I go from here thanks?

Link to comment
Share on other sites

Left( field, Position( field, "_", 1, 1 ) - 1 )

This calculates the position of the underscore and gives all characters to the left of it.

Link to comment
Share on other sites

This topic is 7238 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.