Truncating data

[Alylia]

Hello,

Sometimes ago, I requested and got help on truncating the last three digits
from a field with data of the following format ????-????-???. I would
appreciate help on truncating the just the middle four digits.

I tried truncating the last eight and then based on the result obtained,
truncate the first four. It worked but the problem is that I cannot query on
the truncated data as I get an error.

Thanks for your support.

 

[Alylia]

Thanks for your support, but what I actually wanted was the middle four digits

 

[Ofer]

To remove the four middle char, include the dash ("-")

=left(FieldName,4) & right(FieldName,3)

 

[Ofer]

In that case
=mid(FieldName,6,4)

 

[Alylia]

Thanks a million. That was exactly what I had wanted.

 

[Alylia]

Your support is much appreciated.

Thx

If there dashes then use this --
Right(Left([YourTable].[YourField],9),4)

If there are no dashes then use this --
Right(Left([YourTable].[YourField],8),4)

To query on the truncated data use this --
Like "*" & Right(Left([YourTable].[YourField],8),4) & "*"

Hello,

Sometimes ago, I requested and got help on truncating the last three digits
from a field with data of the following format ????-????-???. I would
appreciate help on truncating the just the middle four digits.

I tried truncating the last eight and then based on the result obtained,
truncate the first four. It worked but the problem is that I cannot query on
the truncated data as I get an error.

Thanks for your support.