Calculation Within a Field

[ScottBaxter]

Hello,

 

I need to do the following within a calculation field:

 

If (Field = "Current"; Left(Name; 7) ; )

 

But it doesn't seem to work.

Can anyone help me out?

 

Thanks,

Scott

[Raybaudi]

If (Field = "Current"; Left(Name; 7) ; )

 

isn't correct; try:

 

If (Field = "Current"; Left(Name; 7) )

[ScottBaxter]

Hi Daniele,

Thanks for the quick response.

 

I have a field that I just want to show the first 7 characters... If it has more then 7 I want it to remove the rest?

 

Is this possible?

 

Thanks

[Raybaudi]

So, if you have the field "Name", the caculated field must have this calc:

 

Left ( Name ; 7 ) 

[ScottBaxter]

I have a field called Name I want to copy this field but the max characters I can have is 7 anything over this I want to remove?

 

Is this possible?

[Raybaudi]

Did you try the calc above ?

[ScottBaxter]

Yea it gives me a number when I export the records?? Not what the value of that field is?

[Raybaudi]

A pratic example:

The field "Name" contains: ScottBaxter

The calculation field, result text, will have: ScottBa

[ScottBaxter]

Sorry my fault the result was set to number...

 

Thanks for your help!!