remove leading "-" 1

[jomarelectric]

cr10

hello, all.

i have a field that returns the value w/ a "-" preceeding the numbers in the field (to indicate a payment has been applied).

i'd like to strip this out. could someone please set me off in the right direction.

as always, thank you.

 

[Kendel]

Replace("yourStr","-","")

 

[dgillz]

Is this a string field or a number field and the "-" is simply a negative sign?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[jomarelectric]

it's a number field and the "-" is a negative sign - you're right.

//frank

 

[Kendel]

If it's a number field, all you need is a Abs() function.

 

[dgillz]

Or you can format the field to have no negative symbol.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown