Dear all
I have an excel file, the excel form as follows
In Row D, from D2 is 16 December 2019 , how could I change the content to 20191216?
in Row E, i want to change the data ISIN: to ISIN delete the :
in Row F , i want to change the data BACE/ to BACE , delete the /
how could I achieve these function ? anybody give me demo code ?
thanks a lot in advance.
kuppu_samy
(Kuppusamy)
December 19, 2019, 7:23am
2
Hi @Chris-Yiwei ,
Read the sheet with D2
.
Make a for each loop, Do the String Replace Operations, DateTime Conversion and Write it into the other file.
For DateTimeConversion: DateTime1 = DateTime.ParseExact(row(0).toString,"dd MMMM yyyy",Nothing)
could you give me the demo code ? i am a freshman thanks a lot
kuppu_samy
(Kuppusamy)
December 19, 2019, 7:32am
4
Please refer this file _Test.xaml (10.2 KB)
dear kuppu_samy
another question , if in Row G , start G2 ,the data is CNG , how could I change to CNH ?
kuppu_samy
(Kuppusamy)
December 19, 2019, 8:58am
6
I couldn’t understand the question, Can you make a file like that? I will tell you the possibilities!
kuppu_samy
(Kuppusamy)
December 19, 2019, 9:05am
8
Based on the _Test.xaml file. In For Each Row activity, you can give
Name = row(3).toString.Replace("Your Text","New Text")
.
Also edit the Build Data Table Activity, add the column name called Name
and Add the Name
Variable in Add Data Row Activity.
Hi @Chris-Yiwei ,
May I have the excel file please?
Thanks & Regards,
Apurba
could you give me some demo code , thanks a lot !
kuppu_samy
(Kuppusamy)
December 19, 2019, 10:54am
12
It’s just based on index values, Please do some Write Line activities, learn it and have a try.
could you show me some demo code ? thanks lot in advance