Want to change 1,2,00.00 to 1200 in excel
Hope this expression would help you
Str_output = split(Str_input,”.”)(0).Replace(“,”,””)
The we can use this str_output to be entered in excel either with write cell or with assign actinside a for each row loop
You can use this component to do it easily without much coding.
Use String Format Activity
Here is an activity to change the cell format in the excel.