Checking rows,find and change in Excel

Hello,
The work-flow is,
1)Check all rows and column in excel.
2) Ç and ç will be C or c, Ş and ş will be S or s…
Example for; “Şebnem Çakır” will be “Sebnem Cakir”.

Could you explain how to do this?
Regards.

1 Like

In that case we can convert the whole excel file to a datatable and converting that datatable to a string and searching in that is very feasible
—use a excel application scope and pass the file path as input
—Inside the scope use a read range activity and get the output with a variable of type datatable named outdt
—now use a activity called OUTPUT DATATABLE ACTIVITY where pass the above variable as input and get the output with a variable of type string named str_output
—now we can search and replace with str_output = str_output.Replace(“yourcharacter”,”requirescharacter”)

Then we can use a GENERATE DATATABLE Activity and pass the above string variable as input which will give us a datatable variable
—we can use that as input to write range activity to enter it into a excel

Hope this would help you
Cheers @Muhammet_Duzparmak

1 Like

Ç must be C,
so ı ve to use assign activity and ı ve to right str_output = str_output.Replace(“C”,“Ç”) ? or “Ç,C” which one?

Small correction buddy
str_output = str_output.Replace(“Ç”,”C”)

Cheers @Muhammet_Duzparmak

1 Like

so ı ve to make for them all like,
str_output = str_output.Replace(“Ç”,”C”)
str_output = str_output.Replace1(“Ö”,”O”)
str_output = str_output.Replace2(“Ş”,”S”)
and I will use Gen. Data Tables for all of them?

1 Like

Yah
Cheers @Muhammet_Duzparmak

1 Like

Thanks a lot sir. I ll make them all and let u know :slight_smile:

Cheers.

1 Like

Fantastic
Cheers @Muhammet_Duzparmak

Sir,
Is there enough only one generate data table?

1 Like

Yes one would be enough buddy
Cheers @muhamad.azizi

1 Like

Sir Hello,

I couldnt do exactly what u said. Is it possible to contact by skype? If ı share screen u can explain me better I guess.

Regards.

Kindly share your workflow if possible pls
Cheers @Muhammet_Duzparmak

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