datatype issue

[Anonymous]

Hi I have filed global, by datatype its showing as text in table viewer but data in it is numeric. so when I'm trying to use section by using left function its not working ..could someone please help me to resolve this.

John

[sunny_talwar]

Can you share a sample within the field you are talking about?? You might be able to fix it using Num#() function, but to give you more detailed answer you will have to share some sample data.

Best,

Sunny

[Anonymous]

Hi Sunny,

let me put it in detail here, I'm trying to apply section access using Filed called global with values

Global              

10000.111

10101.101

10023.11

100003.23

when I use left(global, 3) as sectionAccess   left(global, 4)  as sectionAccess and upper(global) as sectionAccess.

only the values of upper(global) is being accessed.

here the dataype of global field is text but the data is numeric, how do we go for left or right function in this case

John

[sunny_talwar]

What happens if you use it like this:

Upper(Left(global, 3)) as sectionAccess or Upper(Left(global, 4)) as sectionAccess

Not an expert with Section Access, so I might not be giving you a solution you are expecting, but I definitely going to learn something new while contributing here

Best,

Sunny

[Anonymous]

sry Sunny , actually i missed in the above post, i used upper in all the cases, but only upper(global) is getting selected where as others Upper(Left(global, 3)) & Upper(Left(global, 4)) were being greyed out.