Summary information from excel files into one excel file

rahatadi · January 30, 2019, 9:39am

will you please add xlsx file aslo ?

trunghai · January 30, 2019, 9:41am

rahatadi · January 30, 2019, 9:50am

in which column you want to update new value?

trunghai · January 30, 2019, 9:59am

I want to assign D column.

Example : D2 = A2&“/”&B2
D3 = A3&“/”&B3…

^^

rahatadi · January 30, 2019, 9:59am

check this

trunghai · January 30, 2019, 10:02am

@rahatadi
Thanks you so much… I will check and inform to you tomorrow.

Thanks you thanks you so much always man ^^

trunghai · January 31, 2019, 1:35am

@rahatadi
Hi, the result is correct ^^
Thanks man!

trunghai · January 31, 2019, 1:39am

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 ?

rahatadi · January 31, 2019, 2:39am

Should specify some character in “tobeReplacee” argument.

rahatadi · January 31, 2019, 2:41am

Just tell me how the result will look like at end?

trunghai · January 31, 2019, 3:06am

Example : 29/01/2019 will replace into 29.01.2019

^^

rahatadi · January 31, 2019, 3:41am

import system.text.regularexpression dll
use

Regex.Replace(“29/01/2019”,“/”,“.”).ToString

trunghai · January 31, 2019, 3:57am

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

rahatadi · January 31, 2019, 3:59am

this should work…

Regex.Replace(NgayTK,“/”,“.”).ToString

trunghai · January 31, 2019, 4:16am

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 ^^

rahatadi · January 31, 2019, 4:24am

wish you the same

system · February 3, 2019, 4:24am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.