will you please add xlsx file aslo ?
hi KienACC.xlsx (9.6 KB)
in which column you want to update new value?
I want to assign D column.
Example : D2 = A2&“/”&B2
D3 = A3&“/”&B3…
Excel to Excel TRIM.xaml (12.8 KB)
Thanks you so much… I will check and inform to you tomorrow.
Thanks you thanks you so much always man ^^
Hi, the result is correct ^^
I have used Assign Activity to replace the special Character “" to “.” with command :
NgayTK=NgayTK.Replace(”",“.”)… but it could not replaced.
This command has any not correct ?
Should specify some character in “tobeReplacee” argument.
Just tell me how the result will look like at end?
Example : 29/01/2019 will replace into 29.01.2019
import system.text.regularexpression dll
Hi, I want to replace all of value in B Column.
All of the date in B column will be replaced from xx\xx\xx to xx.xx.xx
this should work…
hehe… Thanks you so much man ^^
I will have an " TET " holiday from tomorrow to 11/2/2019
See u again & Happy New year to you ^^
wish you the same
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.