Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use Purgechar(FieldName,'%') as FieldName , It removes % symbol..
Hope it helps
Num(left(FIELD,2),'#,##0.00%')
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 ?
Hi,
You can use Purgechar(FieldName,'%') as FieldName , It removes % symbol..
Hope it helps
Try this
Replace(CELLVALUE,'%','')&'%' AS FieldName
or
PurgeChar(CELLVALUE,'%')&'%' AS FieldName