Reference with 1st two letters of name

[Giancarlo Migoni]

Hi, is there anyway by calculation to assign in a field "REGISTRATION No" the first two letters from the field "Name" + 3rd and 4th letter from the field "Last Name" + last 2 digits from the field "dathe of birth" ??

THANKS

GIAN

[Lee Smith]

Left (Name; 2) & Middle (Last Name; 3; 2) & Right (date of birth; 2)

I did not try this out, but I think this will give you the idea.

Lee

oops had an extra (

I changed the calculation here.

Edited January 27, 2008 by Guest

[Giancarlo Migoni]

it's almost close but not working

[Lee Smith]

I made a change to the calculation, did you catch that.

Saying it is close, but doesn't work, is not very helpful.

Give me an example of what the data (for the three fields) looks like, and what the result of the calculation was.

Lee

Edited January 27, 2008 by Guest

[Giancarlo Migoni]

Hello Lee, well..... when i type the action as you said, it just doesn't alow me to enter that way. using ";" i use everything and a can't make it work.

[Lee Smith]

post a copy of the file so I can see first hand.

note: this is a open forum, so be sure that your file contains no confidential information.

Lee

[Giancarlo Migoni]

Ok, just let me fix some layout, because now it's a mess. Give me 10 minutes from now. Thanks

[Giancarlo Migoni]

oK HERE IT IS. File Sample

[Lee Smith]

Your sample file is hardly what your question asked.

I have modified your file, which has a Let Calculation to convert the Time for your need. If this helps, you can thank Tony Tanevski, from whom I borrowed the calculation.

In the future, please use the actual facts, instead of a made up one.

HTH

Lee

Lee_Sample.fp7.zip

Edited January 29, 2008 by Guest

[Giancarlo Migoni]

THANKS Lee & Tony to help me out with this matter, but do you remember my first post where i was finding the way to take from (for example) FIELD "LICENCE PLATE" the 1st and the last digit (451TJD)= 4D

How hard do you think this will be, because i tryed the option that you sent to be to use

Left (Name; 2) & Middle (Last Name; 3; 2) & Right (date of birth; 2)?:)?

well in this case will be

LicencePlate(1st and 4th digit)& SERIALNUMBER (4th+8th+last digits)

BEST PERSONAL REGARDS

Gian

P.S. The original file it belongs to the government, i signed a non disclosure agreement, so that's the way i just made up the one you saw. Sorry about that.

[Lee Smith]

That was why I made the note:

Try this calculation:

Be sure the field is Text Result

//LicencePlate(1st and 4th digit)& SERIALNUMBER (4th+8th+last digits)

Left ( LICENCE PLATE ; 1 ) & Middle ( LICENCE PLATE ; 4 ; 1 ) & Middle ( SERIAL NUMBER ; 4 ; 1 ) & Middle ( SERIAL NUMBER ; 8 ; 1 ) & Right (SERIAL NUMBER; 2) & Let(

[

xHr = Hour(CREATION TIME);

xMin = Minute(CREATION TIME)

];

Case (xHr < 10; "0") & xHr & Case(xMin < 10; "0") & xMin

)

[color:blue]4T53202135 is the result I got.

Lee

Edited January 29, 2008 by Guest

[Giancarlo Migoni]

LEE...... YOU ARE THE MEN!!!

Thank you so much for your help buddy.

It works at 100% now.

Best Regards

Gian

[Lee Smith]

u r welcome.

Hopefully you, and others following this thread, now understand how important it is for us to have pertinent information in order to provide a workable solution.

Lee