Load string as number

[markp201]

Amount
0.00 800.00 1,203.12 901.00 235.00

I applied num#(Amount) as Amount and get

Amount
? ? ? ? ?

1. Why right-justified if its not a number?

2. Why the ? mark

[sunny_talwar]

Try this may be

Num#(Amount, '#,##0.00')

[markp201]

Same result.  Returns ?

[Anonymous]

are your system variables set like that?

SET ThousandSep=',';

SET DecimalSep='.';

[sunny_talwar]

Would you be able to share a sample?

[markp201]

No change.

I've used num#(field) in a number of places and it works fine.  I don't why this is different.

Why the ?  I would expect null.

[markp201]

This is a very simple script.  

LOAD num#(field) as field.

In other places it works fine

[sunny_talwar]

This is a document specific issue because when I try this.... it works for me

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Table:

LOAD *,

  num#(Amount) as New_Amount;

LOAD * INLINE [

    Amount

    0.00

    800.00

    "1,203.12"

    901.00

    235.00

];

[its_anandrjs]

Did you read the data from any excel file. If possible share sample data.

Regards

Anand

[settu_periasamy]

not sure. May be check this..

Multiple Question mark in list box