TIPS for splitting

Help Activities
1

image
How can I get the string inside the () and make it as my placeholder value on my email body
and how can I save the file path withouth the () ?

2

Different methods are there,

option 1:

using expression

Save the value to your variable - YourString
Assign output variable using below expression

Split(Split( YourString,“(”)(1).ToString,“)”)(0).ToString

image
image835×330 23.5 KB

Option 2:

Use Split Text activity

You have to use the activity 2 time

One for splitting using “(” and other for splitting using “)”

then the output will be available in the first part of second activity

1 Like
3

@shanti_18 ,
use the below code in assign activity to get the text inside ()

System.Text.RegularExpressions.Regex.Match(yourString, “((.*?))”).Groups(1).Value

Cheers!!

4

@shanti_18

you can use regex to get the values
to extract inside of () this use below pattern - “(?<=().*?(?=))”

Take one assign activity and use below expresion

strInside_Value = System.Text.RegularExpressions.Regex.match(yourstring,“(?<=().*?(?=))”).tostring

Take second assign activity, use below expression
to remove the brackets from your string use below expression
strfilepath = System.Text.RegularExpressions.Regex.Replace(filePath, “([^)]*)”, “”)

5

Hi @shanti_18

Use this expression:
[ extractedString = Split(Split(YourString, “(”)(1).ToString, “)”)(0).ToString ]

Or use two Split Text activities, one to split by “(” and the second to split by `“)”, getting the result from the first part of the second split.

If you found helpful , mark as solution thanks

6

strfilepath is the filename without () right?

7

Hi @shanti_18

Can you try this

Input.Split("(")(1).ToString.Trim(")"c)

The image shows a workflow where an input string "HTI-MP-PO-MM-DD-YYYY" is assigned and then displayed in a message box using split and trim functions. (Captioned by AI)
The image shows a workflow where an input string "HTI-MP-PO-MM-DD-YYYY" is assigned and then displayed in a message box using split and trim functions. (Captioned by AI)922×352 18.2 KB

Regards,

8

@shanti_18

Yes, strfilepath is the filename without the parentheses () if you used the Replace method to remove them. For example:
strfilepath = YourString.Replace(“(”, “”).Replace(“)”, “”)

9

can i send the strfilepath as an attachment to my email?
it should be
strfilepath = C:\RPA\HTI-MP-PO-MM-DD-YYYY upon sending

10

strfilepath="C:\RPA\"+Input.Split("(")(1).ToString.Trim(")"c)

11

@shanti_18
Yes, you can send strfilepath as an attachment in your email. To format the strfilepath as C:\RPA\HTI-MP-PO-MM-DD-YYYY upon sending, you just need to dynamically build the path using the current date.

Example:
strfilepath = “C:\RPA\HTI-MP-PO-” & Now.ToString(“MM-dd-yyyy”) & “.txt”

12

@shanti_18 , It just remove brackets and text wont remove inside of the brackets

13

If you want remove the entire thing whatever data is there inside of the brackets

use below expression

strfilepath = System.Text.RegularExpressions.Regex.Replace(inputString, “([^)]*)”, “”

14

newfilename as string
value System.Text.RegularExpressions.Regex.Replace(FilePath(0), “(.*?)”, “”).Trim

how can I make this as an attachment to my email sending?

15

@shanti_18

try to look out in you mail activity there will be a option to attach the files, there you need to give full file path.

if you are storing it in a variable verify that variable contains full path of the file or not.
then pass that variable in attachment section

16

okay, but how can I rename the file? to the new format

17

for that you can use rename file activity to rename the file

18

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