Hi Sir,
I got your solution now I want to write those dates into excel.
I am getting error on foreach loop
@SOURAV_KUMAR_DAS
Add that Build Data Table Above the While Loop
Add Add Data Row Inside the While Loop.
@SOURAV_KUMAR_DAS
yes it should be Added in While Loop…because we are not adding those dates in any collection.if we doesn’t add in While Loop It will take only Last date.
For your understanding i Have made Changes in workflow so take a look it.GetDates_Between_Two_dates.xaml (7.9 KB)
Hi Sir,
Thank You Sir for your solution.
Keep it on Sir…
@SOURAV_KUMAR_DAS
Use If Condition and use following code in it.
TempDate.DayOfWeek.ToString<>"Saturday" Or TempDate.DayOfWeek.ToString <>"Sunday"
Then in the Then part move that Add Data Row.
Hi Sir,
For confirmation I have shared you the image…
Hi jitendra_123 Sir,
No Sir it is not working Sir, it’s getting Saturday as well as Sunday dates in the excel sheet.
Hi jitendra_123 Sir,
I have another question
How to extract searched text from PDF file of online document?
if there’s any solution please let me know Sir.
Hi jitendra_123 Sir,
Yes Sir.
This is the link Sir.
http://clists.nic.in/ddir/PDFCauselists/madras/2019/Oct/01331102019.pdf
Hi jitendra_123 Sir,
If my searched text is “TCA/796/2019” in the current pdf link
http://clists.nic.in/ddir/PDFCauselists/madras/2019/Oct/01331102019.pdf
then it should extract these message and write it in any document.
so can you explain in sample workflow.
@SOURAV_KUMAR_DAS
Download that PDF and Use Get OCR Text.
then using regex Extract only those text that you want to extract.