You can update to the highest version that is available in your studio @Lalitha_Selvaraj
Select the highest version and keep the run time rule Lowest as Applicable and it should work !!
Regards
Actually its taking time. Can you send the regex and the screenshot of the .xaml file.
Sure @Lalitha_Selvaraj
str_Text = str_Text.Replace("_","")
Matches = System.Text.RegularExpressions.Regex.Matches(str_Text,"\d+.*Fu[\s\S]*?\d+\s*\-\s*\d+.*")
Name = System.Text.RegularExpressions.Regex.Match(MainMatch.ToString,"(?<=Name.*)([A-Za-z ]+\s*.*)(?=2\.)").Value.Replace(" ","").Trim
DOB = System.Text.RegularExpressions.Regex.Match(MainMatch.ToString,"(?<=yyyy.*)(\d+.*)").Value.Replace(" ","").Trim
Regards
Have you tried? @Lalitha_Selvaraj
Regards
Hi @vrdabberu . yes I have tried, For some pdf text its working and for some pdf text its not working.
Can you share the tex file for which the code isn’t working? @Lalitha_Selvaraj
Regards
Sorry for bothering you. Can you send Regex alone so that I can import it in my code.
Here the Full name or FuIIName(take capital i instead of L) keeps changing.
the regex which you mentioned earlier is working fine but its selecting more values(since its general).
([A-Z]+\s*)_.*
sample textfile1.txt (730 Bytes)
These are some of the extracted text from multiple pdf’s.
My .xaml screenshot
Requirement:
Extract pdf text into csv using substring/regex
Steps which I added in code.
- Extracting text from pdf (for some pdf used OCR, For some pdf used read pdf text)
- store it in text file.
- extract few field values from text file using regex/substring/split activities
- save it in csv .
Sure I will send the regex alone @Lalitha_Selvaraj
I have just executed the code with the latest text file you have provided in the recent post and observed that all the values are extracted as per your requirement by without changing any regex expressions in the code so can you please let me know in what file exactly the error is coming.??
Here is the required output for the latest file you have provided:
Regards
Hi @vrdabberu . Can you send the text file which you have used for this expression.
sample textfile1.txt (730 Bytes)
I have attached the text file please check @Lalitha_Selvaraj
Can you share your workflow i will check that. The screenshots you have attached were not clear.
Regards
Please find the workflow.
Sequence1.xaml (13.2 KB)
Untitled.xlsx (7.1 KB)
You need to place the Add Data Row within the for each so make the changes accordingly:
Regards
Hi @vrdabberu.
It’s working. I have few more fields in text file which is in need of regular expressions.
Sure i will help with that @Lalitha_Selvaraj
If you find the solution for the present topic please do mark the solution for the post and raise a new topic.
Regards
Thank you @vrdabberu . I will post a new topic soon.