Hello all,
I need help to extract a specific login and password from text string :
My Inpute String after displayind it with a WriteLine activity it’s like the below:
\t\t\t\t \t\t\t\t\t\t \t \t \t\t\t\t \t\tAdditional credentials, to enter in specific popup box when prompted for authentication.username: in_UsernamePassword: in_Password \t\t \t\t\t\t\t \t\t\t\t\t \t\t\t \t\t\t \t\t\t \t\t\t\t \t\t\t\t \t\t\t"
My desired outputs is the :
Thank’s
hi @o.mustapha- Please try this…
Pattern for UserName: (?<=username: )\w+(?=P)
Pattern for Password: (?<=Password: )\w+
please could you provide me the right syntax to implement in a assign activity
This will work only if username is without any spaces and password does not contain any special characters.
You have to use Matches activity where Input will be your Input variable i.e. text
In Pattern pass the regex
and output you will have collection of matches based on the input
@KannanSuresh -Agree… I have provided the regex pattern based on the user Input…You can bring n no.of assumptions into this…Assuming all those and writing the pattern is tough
Might be the case with password. However, for username, the below pattern should work.
(?<=username: ).*(?=Password: )
Well it’s working now !!
thanks a lot
Best Regards
@o.mustapha - Like this.
StrOutput = System.Text.RegularExpressions.Regex.Match(“\t\t\t\t \t\t\t\t\t\t \t \t \t\t\t\t \t\tAdditional credentials, to enter in specific popup box when prompted for authentication.username: in_UsernamePassword: in_Password \t\t \t\t\t\t\t \t\t\t\t\t \t\t\t \t\t\t \t\t\t \t\t\t\t \t\t\t\t \t\t\t”,“(?<=username: )\w+(?=P)”).Value
@o.mustapha - If you see any issues, you can adjust it as @KannanSuresh mentioned…
Thank’s all. my data manipulation work fine now, I apreciate all your helps
Best Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
