Remove last 8 character ?

[Former Member]

Hi  Friends ,

I have a database filed Note .

I want to remove last 8 character from the note field . how to do this .

Ex : if i have data like  ' Contact Sap Community network for crystal queries '   ,

i need to display

' Contact Sap Community network for crystal' 

[Former Member · Accepted solution]

Hi Lenin,

Write below code inside a formula and place it in 'Details' section.

left({table.field},len({table.field})-8)

{table.field} represents the column in your table.

Thanks,

Prathamesh