KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


2 posters

    Replace a comma with a dot in a table

    avatar
    andobe


    Posts : 14
    Points : 2102
    Join date : 2019-03-22

    Replace a comma with a dot in a table Empty Replace a comma with a dot in a table

    Post by andobe Tue Mar 26, 2019 10:42 pm

    Hello, me again.

    I am extracting a value from an excel but it comes with a comma separator, can anybody advise how i can write the SQL or any other means that can replace that with a dot instead? Number looks like this for example: 23,422

    Thanks in advance!
    jking
    jking


    Posts : 103
    Points : 4053
    Join date : 2014-03-01
    Location : USA

    Replace a comma with a dot in a table Empty Re: Replace a comma with a dot in a table

    Post by jking Wed Mar 27, 2019 2:24 am

    In your extract step add a Converter → Number Handling → Extract  Number.
    Add an additional Converter if you need a specific number format.


    Replace a comma with a dot in a table Number10

      Current date/time is Fri Nov 15, 2024 4:29 pm