Copy "/" and paste in a column with dates

Help Activities
, ,
1

Hi all;

I have a file whose column Q has dates.
I would like a simple method to replace the “-” by “/”.
Thanks in advance for your quick help.
CHA

2

If you reading data as a string, then you can use YourStringVariableName.Replace(“-”,“/”)

3

Thanks to your feedback but how do you do specify the column Q?

4

Is it an excel file? If yes,
create a count variable(say countVar) and initialize it to 1,
Use a while loop ,
use read cell activity and specify cell value as “Q” + countVar.toString() and store the output value to YourStringVariableName,
now assign YourStringVariableName = YourStringVariableName.Replace(“-”,“/”)
increase countVar by 1,
repeat until there’s data in your Q column

5

Hi @Al_Bert

  1. Read the excel and store in dt1

  2. Then use the invoke code activitiy with dt1 argument as in/out ,

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(ColumnName) = DateTime.ParseExact(row(ColumnName).ToString,“yyyy-MM-dd HH:mm:ss”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy HH:mm:ss”))

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

6

Hi Nived,

OK, the flow is good, but the dates don’t change :pensive:
ReadSEPCRDT.AsEnumerable().ToList().ForEach(Sub(row) row(DateModified) = row(DateModified).ToString.Replace(“-”,“/”))

7

Hi @Al_Bert

Can u show how the output is coming?

8

image
image518×533 33 KB

The flow and the fileimage

9

image

In yellow , that I want
In red the format actual

10

Hi @Al_Bert

I edited my answer

Please check , also while read range , check the preserve format option

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

11

Guys,

I find another way, by a read range on the column Q and write range column Q and the format change automatically.

Thanks to your help and your support.

12

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