Incorrect Data Format while reading calculated fields from SharePoint list

[#1]

The data format is incorrect when I read calculated fields from a SharePoint list into QlikView. For example, I am reading the Material# field into QlikView from SharePoint. The value in SharePoint is "101294675". The  value shown in QlikView is  "float;#101294675.000000".  Is there a script change I can make to ensure the value is diplayed as 101294675

[Anonymous · Accepted solution]

This should work, I think:
floor(subfield("Material#", '#',2)) as "Material#"

[#3]

Thank you Michael.