Trim Function for Other Characters

[CPGDeveloper]

I know the Trim Function will remove leading and trailing blank spaces, but is there any similar function that will remove leading and trailing characters of my choosing? For example, if I want to remove leading or trailing commas, periods, dashes, etc...

 

[Joe4]

Well, there is the Replace function, but that would replace all instances that it finds, not just the trailing ones.

I would recommend creating your own User Defined Function to do something like what you want.

 

[iamkennyj]

Did you ever get help on how to do this?
I have the same situation and could really use some help. Thank you

 

[XOR LX]

@iamkennyj

Perhaps if you give a few examples together with expected results we may be able to help.

Regards

 

[Joe4]

Did you ever get help on how to do this?
I have the same situation and could really use some help. Thank you

Can you provide some more details and examples of exactly what you are trying to do?

 

[iamkennyj]

@iamkennyj

Perhaps if you give a few examples together with expected results we may be able to help.

Regards

I have the a text field with 65.49- in it to represent negative $65.49. I want to remove the trailing - and make it a negative number field

 

[Joe4]

Try this:

IIF(Right([MyValue],1)="-",0-Left([MyValue],Len([MyValue])-1),0+[MyValue])

where "MyValue" is your field name.