Substring or separate information in a column

Help Activities
, ,
1

Hello team UiPath

I currently have an excel file, with two columns

created_time
phone_number

For the created_time column, it is a field that has month/day/time(hour,minute,seconds), and I need to remove the time(hour,minute,seconds), and overwrite the result in that same column or in a new one

For the Phone_number field, I need to eliminate the information of the country code (example: +1,+57+507, etc), and the rest of the telephone fields must be equal to 10 digits, if it is less than 10 digits, eliminate that field or leave it empty.

Best Regards

2

@Julian_Yamid_Torres_Torr1

Can you please show a sample input and output

Cheers

3

Hello

I share the sample

image
image1748×78 5.51 KB

4

Hi @Julian_Yamid_Torres_Torr1

Read the data in a DataTable,
Use a loop on it
inside the loop use
assign

currentRow(“created_time”)= DateTime.Parse(currentRow(“created_time”).Tostring).toString(“dd-MM-yyyy”)

or

DateTime.ParseExact(currentRow(“created_time”).ToString,“d/MM/yyyy-hh:mm:ss”,Globalization.CultureInfo.InvariantCulture).toString(“dd-MM-yyyy”)

5

Hello.

Coudl you share the workflow file ?

Best regards

6

Please provide the input file.

7

Read the excel file to the datatable
loop through every row
make the use of regular expressions
overwrite the value