I'm trying the processor ReplaceText to change all my dot to comma, but i can't I really need some help here, please. This is my CSV file: MONEY (header) 109.29 I need this result MONEY (header) 109,28
... View more
Hello I trying to put some data from my CSV to my database but i got some error. Settings UpdateRecord Settings about CSVRecordSetWriter My csv file: Region Country ItemType SalesChannel OrderPriority OrderDate OrderID ShipDate UnitsSold UnitPrice UnitCost TotalRevenue TotalCost TotalProfit Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06
... View more
Hello I need to change the name of the columns. Ex: 'item Type' became 'Item_Type' Region Country Item Type Sales Channel Order Priority Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Revenue Total Cost Total Profit Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06 i'm trying to use the processor ReplaceText But this is the result Region Country Item_Type Sales_Channel Order_Priority Order_Date Order_ID Ship_Date Units_Sold Unit_Price Unit_Cost Total_Revenue Total_Cost Total_Profit__Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06 Sub-Saharan Africa South Africa Beverages Offline H 07/10/2012 482292354 8/21/2012 9880 47.45 31.79 468806.00 314085.20 154720.80 Can someone help me please?
... View more
