Delete parts of a string

[tigertim71]

Hi,

I am trying to delete a part of a string but not all of it.

For example; American Express Inc. I would like to delete only the "Inc.", but leave "American Express".

How is this done?

Many Thanks,

Tim

 

[pbaldy]

One way would be the Replace() function. More info in Help.

 

[doco]

Trim( Left( "American Express Inc", Len( "American Express Inc" ) - Len( "Inc" ) ) )

 

[tigertim71]

OK- thanks.

This worked:
Replace([Teams.Team],"Inc."," ")

This worked, but not in the 'update to' area of the query:
Trim( Left( "American Express Inc.", Len( "American Express Inc." ) - Len( "Inc." ) ) )- it says 'The expression you entered has an invalid. dot or ! or operator or invalid parentheses'.

 

[doco]

Hmmm... Just typed that snippet into the Immediate Window and hit Enter

?Trim( Left( "American Express Inc.", Len( "American Express Inc." ) - Len( "Inc." ) ) )
American Express

Looks like it is working for me...