Remove thousand separator from result produced by a shortcode?

  • Resolved joncwhall

    (@joncwhall)


    5 years, 4 months ago

    Hi,

    I have a shortcode in my table that displays a number with the thousand separator. Eg: 4,178.

    When I reference that cell in another one it produces a error message.

    What I think would work best would be to have a hidden column that produces a usable number from that shortcode cell and then reference this column in other calculations if you know a way to do that please?

    Thanks,

    Jon

Viewing 1 replies (of 1 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    5 years, 4 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    Unfortunately, I don’t have a solution for that. TablePress can not remove the thousand separator before doing calculations.
    Can you maybe modify the used Shortcode so that it removes the comma? You could then use that for the calculations. Using the NUMBER_FORMAT() function it would then be possible to again add the comma as a thousand separator, when the result is displayed.

    Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Remove thousand separator from result produced by a shortcode?’ is closed to new replies.