String concatination with space in between

.

Hello All,

I am trying to contactenate 2 strings with space in between.The formulae works in excel but throws error in UI .How to rectify this error?

Eg , First name in column 1 last name in column 2 - 3 rd coulmn Name but with space inbetween first and last name .

Thanks,
S

Try this String1 +" "+String2

why not just type “=(A2 B2)”

Hi ,

I am storing as datatable , column a, column B .How do i use your answer in that scenario ?

Thanks,
S

Hello ,

If i use your suggested solution , column c is populated with : #NAME?. I need column a +" " + column B into column C . I am using datatable .

Thanks,
S

@Sharmi_thangam_malat

You can use following code -

User For Each Row in dt

Add assign activity inside For Each ,

row(“Column3”) = row(“Column1”).ToString+" " + row(“Column2”).ToString

Write Range the table dt in the same sheet with Add Headers Checked

Thanks,
Madhura

2 Likes

Hello,

Thank you ! Your solution worked .

Regards,
S

Hi Madhuraj,
I’m trying to send email with mail body as per below using send outlook mail message
Dear Vinay,
Your ID 80000237 has been created In WF And password Is ab@cd
Regards
Vinay Kumar
P2P WorkFlow
Mob 1234
EBEX
But getting out put
DearVinay,
Your ID80000237has been created In WF And password Is ab@cd
Regards
Vinay Kumar
P2P WorkFlow
Mob 1234
EBEX
Used code, please support i want space after Dear and after to string.
“Dear” +row (0).ToString+"," +Environment.NewLine+""+Environment.NewLine+
“Your ID”+row(2).ToString+“has been created In WF And password Is ab@cd”+Environment.NewLine+""+Environment.NewLine+“Regards”+Environment.NewLine+“Vinay Kumar”+Environment.NewLine+"P2P WorkFlow "+Environment.NewLine+“Mob 1234”+Environment.NewLine+“EBEX”

@vinay7835,

Since you are hard coding the string “Dear” just provide the space after it. That would work for you. and follow the same after ID value also.
Ex: "Dear "

Sid

Thanks can you tell me how can i do same activity without hard coding

@vinay7835,

For not hard coded values, you can follow like how madhuraj or other mentioned above.

Sid

(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)

Please help on below

@vinay7835,

please check all your strings are returning values or not. you might be passing some null values so you are getting that exception.

Thanks,
Sid