locked
Excel Number Format problem?? RRS feed

  • Question

  • User-1104215994 posted

    Hi,

    I am reading an excel sheet and converting it to an XML. The problem is I would like to convert the decimal separator. How can I do it?

    best regards.

    Here is sample data from excel:

    80,00

    1.354,00

    But I want them as folloes:

    80.00

    1.354,00

    Friday, July 8, 2011 8:52 AM

Answers

  • User-359936451 posted

    look up the replace function...

     

    Syntax

    REPLACE (
    '
    string_expression1' , 'string_expression2' ,
    '
    string_expression3' )

    Examples

    This example replaces the string cde in abcdefghi with xxx.

    SELECT REPLACE('abcdefghicde','cde','xxx') GO 

    Here is the result set:

    ------------ abxxxfghixxx (1 row(s) affected) 
     
    In SQL
    SELCT REPLACE ('yourstring','.',',')
     
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, July 10, 2011 6:03 PM