Skip to main content
September 2, 2022
Solved

Remove separators from an integer

  • September 2, 2022
  • 2 replies
  • 0 views

If I have a list of integers as inputs in an expression such as: 8.651.134;7.236.458;6.124.536 etc, how can I remove the thousand separator dots to leave them as 8561134;7236458;6124536?

    Best answer by stefanhelzle0001

    tointeger(
      split(
        substitute(
          "8.651.134;7.236.458;6.124.536",
          ".",
          ""
        ),
        ";"
      )
    )

    2 replies

    stefanhelzle0001
    Brainy
    September 2, 2022

    tointeger(
      split(
        substitute(
          "8.651.134;7.236.458;6.124.536",
          ".",
          ""
        ),
        ";"
      )
    )

    harshitb6843
    September 2, 2022

    stripwith(value,".")