How to remove date and replace it with void (null) in UiPath Studio using RegEx?
I have this statement as a problem statement which is given below:
Date: 27.07.2023
Pages: 2
Requested by: N_RAHUL
Here need to change Date “27.07.2023” with Null
and also Requested by “N_RAHUL” to Null
Kindly help me how to do this using RegEx in UiPath???
Replies with screenshots will be appreciated. Thank you in advance!
Assign activity: modifiedText = System.Text.RegularExpressions.Regex.Replace(inputText, "Date:\s\d{2}\.\d{2}\.\d{4}", "Date: Null")
Assign activity: modifiedText = System.Text.RegularExpressions.Regex.Replace(modifiedText, "Requested by:\s\w+", "Requested by: Null")
The regular expressions used in the “Assign” activity are as follows:
"Date:\s\d{2}\.\d{2}\.\d{4}"Explanation:
Date:: Matches the literal text “Date:”.\s: Matches a whitespace character (space).\d{2}: Matches two digits.\.: Matches a literal period (dot).\d{4}: Matches four digits."Requested by:\s\w+"Explanation:
Requested by:: Matches the literal text “Requested by:”.\s: Matches a whitespace character (space).\w+: Matches one or more word characters (letters, digits, or underscores).These regular expressions identify the parts of the input text that you want to replace and replace them with “Null”.
Hope it helps!!
Both assign activities are named as “modifiedText” in the above statement…Is that correct?
You could just do…
Assign inputText = System.Text.RegularExpressions.Regex.Replace(inputText, "Date:\s\d{2}\.\d{2}\.\d{4}", "Date: Null")
Assign inputText = System.Text.RegularExpressions.Regex.Replace(inputText, "Requested by:\s\w+", "Requested by: Null")
I see so many people overcomplicating things by creating extra variables for no reason.
Yes,Correct
You could also do it all in one statement…
Assign inputText = System.Text.RegularExpressions.Regex.Replace(System.Text.RegularExpressions.Regex.Replace(inputText, "Requested by:\s\w+", "Requested by: Null"), "Date:\s\d{2}\.\d{2}\.\d{4}", "Date: Null")
System.Text.RegularExpressions.Regex.Replace(yourinputstring, "((?<=Date:\s+)\d+\.\d+\.\d+)", "Null")
System.Text.RegularExpressions.Regex.Replace(yourinputstring, "((?<=Requested by:\s+)\w+)", "Null")
Hope it helps
Ok will try and let you know…
Try this
Date= System.Text.RegularExpressions.Regex.Replace(inputText, "\d{2}\.\d{2}\.\d{4}", "Null")
Name = System.Text.RegularExpressions.Regex.Replace(inputTextDateReplaced, "(?<=Requested by: )\w+", "Null")
Try the below regex expressions
System.Text.RegularExpressions.Regex.Replace(yourinputstring, "((?<=Date:\s+)\d+\.\d+\.\d+)", "Null")
System.Text.RegularExpressions.Regex.Replace(yourinputstring, "((?<=Requested by:\s+)\w+)", "Null")
Hope it works!!
Thank you so so very much @postwick , @pravallikapaluri , @lrtetala , @vrdabberu for all your efforts and solutions. It worked for me!!! #Grateful
Cheers!
@Yugandhara_Shirbhate
Welcome.
Happy automation.
@Yugandhara_Shirbhate
If you find solution,mark it as solution to close the Loop
Regards
Have one more question…
What if the date changed?.. from 27.07.2023 to any other date? (because I’ve told that date will keeps on changing as that particular document will get downloaded at any date, in which we need to replace date by null)
For that please tell me the RegEx to be used in assign activity
@Yugandhara_Shirbhate
Even though the date changes.
I think it will be in the same format and same place right. So,it will extract with same above solution
Yes.
Okay. Thanks a lot!!! @pravallikapaluri
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
singh_sumit
alonica
SorenB
manasrlenka25
Firat_SECKIN_BULUT
Lahiru.Fernando
ruchirmahajan
RyanTSG
Nitesh