« Previous Next »

• 05-08-2008, 5:57 AM

  JosefVr Joined on 05-08-2008, 5:50 AM Posts 3	comma as decimal point in number Reply Contact Does logparser support localized numbers (decimal point is comma) in csv file? If so, is there anything special needs to be done to get this going? Thanks!
  	Tags: CSV and TSV input formatsQuantize CSV Input

• 05-12-2008, 5:32 AM

  In reply to

  Zhao Ji Ma - MSFT Joined on 01-05-2007, 5:36 AM Posts 765

  Re: comma as decimal point in number Reply Contact Hi Josef, If the file can be treated as TSV file, then the separator can be specified with -iSeparator:(character) parameter. For example: -iSeparator:space Zhao Ji Ma Sincerely, Microsoft Online Community Support “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”

• 05-12-2008, 8:11 AM

  In reply to

  JosefVr Joined on 05-08-2008, 5:50 AM Posts 3

  Re: comma as decimal point in number Reply Contact Hello, thank you for your response. However, I haven't got problem with format of input file. The input file is standard CSV file. The problem is in format of numbers in fields of input file. In my country we use as decimal point the "comma" instead of "dot" and when I use some function (AVG,SUM,...) I have this error: Error: SELECT clause: Semantic Error: argument of SUM/AVG/PROPSUM function is no t an INTEGER nor a REAL Regards, Josef

• 05-14-2008, 7:11 AM

  In reply to

  Zhao Ji Ma - MSFT Joined on 01-05-2007, 5:36 AM Posts 765

  Re: comma as decimal point in number Reply Contact Hi Josef, Both Decimal symbol and List Separator of the system are defined in Regional Options.  You can Customize them from here: Control Panel -> Regional and Language Options -> Regional Options -> Customize... Zhao Ji Ma Sincerely, Microsoft Online Community Support “Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. ”

• 05-16-2008, 9:40 AM

  In reply to

  JosefVr Joined on 05-08-2008, 5:50 AM Posts 3	Re: comma as decimal point in number Reply Contact Hi, the settings of Regional Options is correct according my country in spite of the problem still persist (Semantic Error: ...). I've solved this problem using function REPLACE_STR. Thanks. Josef