Currentrow("").ToString is breaking if any space(" ") occurs in string

[sreyanshbaranwal]

I am using creating a project and in that, I am taking names as input from an excel file. For that, I am using Currentrow(“).ToString but the problem is that there’s a space between the first name and last name and Currentrow(”).ToString is not taking the full name it terminates the sequence whenever the empty space occurs. So what should I use to solve this problem?

[Anil_G (Anil Gorthi)]

@sreyanshbaranwal

Can you please show or describe more as it would help us with better understanding and give you a good solution

What do you mean when it sees space?

Cheers

[sreyanshbaranwal]

i have marked spaces by red color
so basically whats happening is if we consider ‘Abhishek Ranjan’ as the current then the UiPath terminates the process just after reading ‘Abhishek’
its not taking full name as input

[Anil_G (Anil Gorthi)]

@sreyanshbaranwal

Can you show your code…as this is not a usual behaviour … or can share a sample xaml here

Cheers

[Rahul_Unnikrishnan]

Hello @sreyanshbaranwal

If you just want to get the name details from the datatable ,**

CurrentRow(“Name”).ToString

** should work fine in the for each Row in Datatable activity.

Thanks

[sreyanshbaranwal]

actually i can’t upload that xaml file because of this

But I was using this template
web.whatsapp/send?phone=+91%22+CurrentRow(%22Phone%22).ToString+%22&text=This%20is%20to%20inform%20that%20your%20ward%20(%22+CurrentRow(%22Name%22).ToString+%22)%20studying%20in%205th%20sem%20Dept%20of%20CSE%20has%20scored%20internal%20marks%20as%20as%20follows:%0aME-%22+CurrentRow(%22ME%22).ToString+%22%0aCNS-%22+CurrentRow(%22CNS%22).ToString+%22%0aDBMS-%22+CurrentRow(%22DBMS%22).ToString+%22%0aATC-%22+CurrentRow(%22ATC%22).ToString+%22%0aPython-%22+CurrentRow(%22Python%22).ToString+%22%0aUnix-%22+CurrentRow(%22Unix%22).ToString+%22%0aEVS-%22+CurrentRow(%22ES%22).ToString

so the bold one that I have to change
I cant use CurrentRow(0).ToString because there are multiple columns and it is giving error also

[Rahul_Unnikrishnan]

@sreyanshbaranwal

Have you tried as mentioned in the screenshot?

Thanks

[sreyanshbaranwal]

Yea i tried buts it’s giving error

[Rahul_Unnikrishnan]

Whats the error that you are getting?

Thanks

[sreyanshbaranwal]

this error i am getting
ETOE.xaml (10.8 KB)
i have attached xaml file also

[Gokul001 (Gokul Balaji)]

HI @sreyanshbaranwal

Change the variable type of the message variable to string.

Can you check all the column names are string type?

In my environment i don’t see any error

Regards
Gokul