negative to posative

[scittneh]

Hello

 

Hopefully someone can help with my question.

 

I have a negative number that i need to change to a positive number.

 

ie. -3 needs to read as 3

 

is this possible?

 

 

thanks in advance.

[aaa]

Hi, scittneh!

Find records with negative numbers.

Then use menu Records/Replase contents/Specify .........

[scittneh]

sorry, i should have said. this needs to part of a script.

[sujat]

Use Abs function. It removes the negative sign.

[doughemi]

Use the Abs[number] function. The Absolute value of a number is always positive, whether the number is positive or negative.

 

If you want to do it on only one record at a time, your script should loop through the records and you would have a script step of

Set Field[myNumberField;Abs[myNumberField]]

 

If you want to convert a whole batch of records at once, perform a find to find the relevant records, and use

Replace Field Contents [myNumberField;Abs[myNumberField]]

 

EDIT:To use Replace Field Contents[], the field must be on the current layout

 

Doug

[Ender]

Use the Abs[number] function. The Absolute value of a number is always positive, whether the number is positive or negative.

 

If you want to do it on only one record at a time, your script should loop through the records and you would have a script step of

Set Field[myNumberField;Abs[myNumberField]]

 

If you want to convert a whole batch of records at once, perform a find to find the relevant records, and use

Replace Field Contents [myNumberField;Abs[myNumberField]]

 

EDIT:To use Replace Field Contents[], the field must be on the current layout

 

Doug

 

Sorry to nit-pick, but use parens instead of square brackets for a function call:

 

abs(myNumberField)

[scittneh]

splendid, thanks for the help people.

[doughemi]

Sorry to nit-pick, but use parens instead of square brackets for a function call:

 

abs(myNumberField)

 

Thanks, Ender. I apologize for the brain cramp.

 

--Doug

[David Head]

EDIT:To use Replace Field Contents[], the field must be on the current layout

Not since version 7 it doesn't. smiley-wink