How to use string expressions with Write Range Workbook

Help Activities
, ,
1

First of all, I apologize for my bad English.

I filtered the string outputs with replace command and I want to print it to excel file with write range workbook activity but I get the error in the picture, how can I fix it?

thank you in advance.

9
91214×792 52.5 KB

2

Hi @emir_ozsimsir

Try like this

CurrentRow("Column")=CurrentRow("Column").ToString.Replace("TL","")

image
image718×589 52.8 KB

3

@emir_ozsimsir

In your case after Extract Table Data activity take For Each Row in Data Table activity in this take Assign activity as

CurrentRow("Column")=CurrentRow("Column").ToString.Replace("TL","")

After that take Write Range Workbook activity

Note: After Extract Table Data activity no need to take Write Range Workbook activity, Read Range Workbook Activity and Output Data Table activity.

I hope you understand!!

4

@emir_ozsimsir

Have you tried this?

5

I apologize for my late reply I use translate to understand. I tried the same thing as you but I get the error in the picture.

11
111301×739 31.6 KB

6

@emir_ozsimsir

Show me the total expression in assign activity

7

Is this the expression you want?

12

8

No, assign activity expression

1 Like
9

Show the expression what you have give in the save to and value field in assign activity.

I think you have missed with some double quotes or you haven’t given .toString to make it string @emir_ozsimsir.

Check the double quotes and concatenation +.

Hope it helps!!

1 Like
10

Both left and right side expressions of assign activity

1 Like
11

as you are using C# the syntax is: CurrentRow[“Fyat…”]…

1 Like
12

14
14866×346 11.5 KB

13

If you are using C# then please try this

CurrentRow[“Fiyat”] = CurrentRow[“Fiyat”].ToString().Replace(“TL”, “”)

1 Like
14

Okay @emir_ozsimsir

Just delete the assign activity and reinitialize the assign activity and values.

I think you are using c# in this project.
Then try to replace the curve braces with square braces.
CurrentRow[“Fyat”] in left side of assign

CurrentRow[“Fyat”].ToString.Replace(“TL”, “”) in right side of assign.

1 Like
15

@emir_ozsimsir

As per the error 1st line once check the data table variable. Read range workbook activity output variable you have to give in for each row in data table activity.

1 Like
16

thanks to everyone for help, problem solved.

1 Like
17

Thank you @emir_ozsimsir

Happy Automation!!

18

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