Is it possible to replace a string in add data row. My scenario is to pass value as arguments into add data row, but it is not accepting null or empty values. So i need to replace the empty value to “-”

You can use StringVar.Replace("","-")

But i need to check for bulk columns (like 15 columns). I cant check each column

For that you need to give individually. I think there is no other way. If it’s an array, you can make a loop and do it.

is there any option to replace the in array

Use For Each Activity and Replace with existing variable.

Awesome If your ArrayRow is of like this with variables holding values in it {variable1.ToString, variable2.ToString,variable3.ToString} Then mention like this in ArrayRow property {IF(string.IsNullOrEmpty(variable1.ToString),”-“, variable1.ToString).ToString, IF(string.IsNullOrEmpty(variable2.…

You can use For Each Activity before adding that row so in for each If item.tostring.trim=“” or string.IsNullOrEmpty(item.tostring) Then Item=“-”

Hi, Create a array with all the variables first. This is similar to the way you specify the valuea as a array row in add data row activity… use an assign activity and specify the array like Array = {variable1, variable2… } Now use a for each activity to loop through the array items Inside the lo…

@aanandsanraj , Thanks for this. it helped me to use for a similar thing in an optimized way.

How to replace value in add data row or array

Help

aanandsanraj (Anandraj Rajendran) December 20, 2019, 6:39am 9

Hi @Rachel7

If you want to replace empty string in an array the below code will help you.

variable1 = variable1.Select(Function(x) x.Replace(" ", “-”)).ToArray()

Replace a value in array

Topic		Replies	Views
Replace a value in array Help activities , variable , question	2	6117	January 24, 2020
How to replace null with some value ? i have tried with multiple logics, can anyone help me please? RPA Discussions coding , general	19	3116	February 21, 2022
Replace empty row with string values Certification activities , studio	9	1786	September 23, 2022
How to replace a null value with empty string in datatable Varaiable Studio studio , question , activities_panel	3	1972	February 18, 2023
How to replace empty data with specific string when Col A, Col B, Col C is empty Automation Starter	9	757	August 29, 2022

How to replace value in add data row or array

Related topics