How do i convert my long string text dollars into positive money numbers? (The negative conversion works.)

FinancePerson — Thu, 27 Jan 2022 15:03:03 GMT

Good morning All,

I am working on a file from another company. The money represented comes over in a text format 16 characters long.

Ex. 0000000000013054

I can get the negative numbers to load with the following script:

if(left(trim([@43:59]),1)='-',num#(right([@43:59],14))/-100,num#(trim([@43:59]))/100) as pay_amount

but the positive numbers wont pull through.

Desired result from ex above: $130.54

Re: How do i convert my long string text dollars into positive money numbers? (The negative conversion works.)

hic — Thu, 27 Jan 2022 16:55:41 GMT

Try

Money(Evaluate([@43:59])) as pay_amount