Format Problem

[#1]

Hi all,

i am reading from an Excel file. Now, in a cell there can be a value 50 or 50%,#

In a chart on the surface i am representing the numbers with num(CELLVALUE, '# ##0.00').

Problem is that the 50 is correctly displayed as 50%, but the 50% is displayed as 5000.00%.

How can i avoid this in the LOAD script ?

Thanks a lot.

L

[#2]

Num(left(FIELD,2),'#,##0.00%')

[#3]

Of course i can have also values like 100% or even 1000% in there....Is there a way to read until the '%' or just read the numeric chars ?

[MayilVahanan · Accepted solution]

Hi,

     You can use Purgechar(FieldName,'%') as FieldName , It removes % symbol..

Hope it helps

[CELAMBARASAN]

Try this

Replace(CELLVALUE,'%','')&'%' AS FieldName

or

PurgeChar(CELLVALUE,'%')&'%' AS FieldName