1 Reply Latest reply on Apr 29, 2020 6:43 PM by Sinisa Mikor

    Getting Rid of ".0"

    Timothy Mobley
      Share This:

      When importing records using AI Spoon, the transformation tagged on a ".0" to the end of a number field. I was wondering if there was an easy way to get rid of all of those ".0"s now that they are in the system?

        • 1. Re: Getting Rid of ".0"
          Sinisa Mikor

          Use integer instead of number in future transformations to restrict data to whole numbers; as to correcting imported data, was data from integration copied into Character field?  In that case and if there is no room for misinterpretation (i. e. there are no numbers stored within the same field which must not be converted into whole numbers), you could use REPLACE(<attribute>, ".0", "") to remove undesired characters; if there is only one number per field, you could also copy that value into temporary (Display-Only) integer field with one Set Fields action, then copy value from integer field back into original field with another Set Fields action, or copy substring consisting of characters preceding ".0" into original field using SUBSTR(<attribute>, 0, STRSTR(<attribute>, ".0")) in Set Fields action.

          3 of 3 people found this helpful