Combining 2 fields

[cmack]

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.

[Lee Smith]

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

Lee

[cmack]

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.

[Lee Smith]

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, 2007 by Guest

[cmack]

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.

[Lee Smith]

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

[cmack]

Thanks so much that worked!!!