Need help on String operations

actions_flow_s
variables
text-actions
#1

Hi,

Need to know how to achieve the following string operations in RPA Express.

  1. Concatenate String. Ex: I have two variable last name and first name. Need to concatenate as full name. Cannot see any option for this in Variables.
  2. Regular Expressions. Ex: Need to get the name alone from a string like Fname from "My name is Fname.

If we do not have such options, can we call any code to get these actions done?

Thanks!

#2

Dinesh, you could use Join strings command for the first task, and separate the string with SPACE.

#3

As for your second question, is the expression always the same, i.e. “My name is Fname”?

#4

Thank you for the reply.

Yes always "My name is " will be same and only Fname changes.

#5

You can use Substring or Substring between action in such case.

#6

Hi,
I have a scenario where i need to join strings with different separators where i can reuse the string using sub string operation and extract the required text based on the requirement. I have all the data in an excel sheet with 4 columns say, Data1,data2,data3 and data4.
Now i get the values into a table variable from excel and perform join string operations, i get the data joined together with separators as in below format:

data1|||???data2|||???data3|||???data4

but i want something like below:

|||data1|||???data2???###data3###%%%data4%%%

Kindly suggest possible ways to achieve the above output

#7

Hi,
I have tried something where i have joined strings from table into two separate list and now how to join strings in two list variable??
data1|||???data2 --------> in a list say temp1
data3###%%%data4 ---------> in a list say temp2

I just wanted to combine both the list now (temp1 followed by separator temp2)
Suggest the possible ways to achieve the output…

#8

Dear @Arthi,

If I understand you correctly, you can combine string variables into the list variable using Expression.

#9

Hi,

Thanks for your reply. I have the data in two list variables (list1, list2) each containing around 5 to 10 items and i want to combine into a single string separated by some separator. Kindly suggest some ways to achieve it.