Hi guys,
I have a pdf file named “Others-Contract-20230731” and I split it in 3 section using CurrentFile.Name.Split(“-”). I’m getting First and Last string (In this case, it means “Others” and “20230731”). But how do I get the middle string (“Contract”)?
If there is anyone who knows the solution, please help me.
CurrentFile.Name.Split(“-”)(1)
When we use split function the output will be stored as a collection. We can use the index to get the value what we want.
Check the below one for better understanding.
Hope it helps!!
@balt-ochir.g
StringVar.Split(“-”.ToCharArray)(0) of 0th index
StringVar.Split(“-”.ToCharArray)(1)of 1st index
StringVar.Split(“-”.ToCharArray)(2)of 2nd index
// Assuming CurrentFile.Name contains the filename “Others-Contract-20230731”
// Split the filename using “-” as the separator
splitResult As String() = CurrentFile.Name.Split("-"c)
// Access the middle string (“Contract”) by using the second element (index 1) in the array
middleString As String = splitResult(1)
// Now the “middleString” variable will hold the value “Contract”
Hope it helps!!
Hey @balt-ochir.g ,
You can assign a string array variable and in left hand side of assign activity type
StrArray = yourfilename.split(“-”)
then you can use strArray(1) = u will get Contract
Assuming you have stored the file name in a variable called fileName, you can use the Assign activity to get the middle string:
middleString.fileName.Split("-")(1).middleString variable will contain the middle string “Contract”.System.Text.RegularExpressions.Regex.Matches(Your input string,"([A-Za-z]+|\d+)")
Hope it works!!
It works! Thank you very much.
Thank you @balt-ochir.g
Happy Automation!!
Thank you very much.
Another way to make it! Thank you very much.
Hi, I tried your solution yesterday and it works. Unfortunately I forgot that I have different type of files. Some files are named “Job Description-20230731” and some are “Others-Contract-20230731” as I mentioned. But when I try to get string with CurrentFile.Name.Split(“-”)(1), it gives me correct string when the file is named “Others-Contract-20230731” but when the file is named “Job Description-20230731” it gives me wrong string (20230731). I want to get first string if there is not any middle string? What should I do? Please help me.
System.Text.RegularExpressions.Regex.Matches(Your input string,"([A-Z\s*a-z]+|\d+)")
try with the regex you will get your output as required.
Regards
use for each and pass the variable into that and with for each try priting the data
What ever the file might be it will print the data as per your requirement.
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
