Trim function on a string ?

[Brad1]

Hi,

How do I get from:  1234567890

To:  456

?

Thanks in advance.

[Brad1 · Accepted solution]

Right(Left([PHONE],6),3)

[sjm · Accepted solution]

Here's one approach, assuming the field is a string:

Substring([FIELDNAME],3,3)

[patrick_digan · Accepted solution]

If you always want the 4-6th characters, you could use: Substring([Field1],3,3)

EDIT: @sjm beat me to the punch...

[NicoleJohnson · Accepted solution]

Two more options, just for kicks :)

If you always want to trim the exact same string from the left & right:

TrimRight(TrimLeft([Field1],”123”),”7890”)

If you always want to trim the same number of digits from the left & right:

RegEx_Replace([Field1],”\d{3}(\d{3})\d{4}”,”$1”)

NJ

[Brad1]

I like it thank you.

[lepome]

By that logic, TrimRight([County ],' County') should work, but it trims all of the letters within the string from the right, not just the complete string.  Moral:  Verify.

[Nicko]

I agree with you, but what is the solution then? If I want it only to remove a specific string segment? In your example "County" from the end of the string.

[Brad1]

TrimRight([city],'county')