Omit trailing value

[sine80]

Greetings, I'm trying to determine how I can omit trailing values of a column. Further, I'm not able to use the val() function due to the preceding numbers are typically 20 characters long, but can be as little as 15 characters.

Ex:

12345-
1234
12345
123-
1-
1

In sum, I need to keep the values less the trailing hyphen. Is there a simple way to accomplish?

Thanks!

 

[boblarson]

You can, in a query, create your own field by using

MyNewName:IIf(Right([OriginalFieldNameHere],1)="-", Left([OriginalFieldNameHere], Len([OriginalFieldNameHere])-1), [OriginalFieldNameHere])

 

[sine80]

Awesome, thank you!

 

[james_lankford]

or
replace (originalField, "-", "")
might be shorter

as long as none of the numbers are negative

 

[boblarson]

or
replace (originalField, "-", "")
might be shorter

as long as none of the numbers are negative

Don't know - can you use an empty string on numbers and still have them remain a number?