I have 2 fields that I want to take part of each and put it in a 3rd field.

I was trying make a calculation with Left and Right but it never seems to work. I have searched the forums for similar cases, and I am sure there are, but I don't seem to be using the correct words to search.

If any one can help I would really appreciate it.

Field 1 is Package and has *DA6C* it will always contain the same number of characters.

Field 2 is Team and has *6A* and it will always be the same length.

In my other field I need the *DA6C from the Package field and the 6A* from the Team Field.

The final result would be *DA6C6A*

Is there a simple way to do this?

Thank you and I apologize if this is somewhere in the forums already.

You need to give us an example of the whole field content for both fields.

Lee

I am sorry I thought I did.

The package field will contain

*DA6C* or something like it. *HG7B* or *DI8E*

it will always have the same number of characters (4 + the 2 asterisk)

The team field is similar. It will also have 2 asterisks but only 2 other characters)

such as:

*6A* or *7H* or *8R*

I need the 2 together but I only need one asterisk at the beginning and one at the end.

So I would like the PakTm field to look like:

*DA6C6A* or *HG7B7H* or *DI8E8R*

Using the above 3 as examples. I hope I am explaining it correctly.

See if this does if for you

"*" & Filter ( [color:blue]package ; "0123456789ABCDEFGHIJKLMNOPQRSTUVWKYZ" ) & Filter ( [color:blue]team ; "0123456789ABCDEFGHIJKLMNOPQRSTUVWKYZ" ) & "*"

You have to change the [color:blue]package and [color:blue]team to your fields.

Lee

Edited October 18, 200718 yr by Guest

The package and team fields will change. In the examples above those would be 3 separate records which I don't think I said very clearly.

What will remain the same are the asterisks and the number of characters between the asterisks.

Does that make any more sense?

Thank you for your reply.

I'm confused, but I don't think your data will matter, unless there are small alphabet letters. Here is a sample I made you, see if this what you mean.

If not, then post a bigger sample of your data.

Lee

cmack.fp7.zip

Thanks so much that worked!!!