Extract text from Text file

[Beginner1234]

Hi all,
I have a scenario. I’m receiving a text file in that i will be having questions, question options and the answers. Now i need to extract only questions and answers and store them in another text file. How to achieve this. I’m looking this solution either in text file or word file. Anything is ok for me. Any suggestions.

Sample text file attached below for reference

Sample questions Multiple choice.txt (560 Bytes)

I need output like this.

1. How did you find out about our product?

Answer : b

2. What industry are you in?

Answer : d

[Yoichi]

Hi,

How about the following sample?

mc = System.Text.RegularExpressions.Regex.matches(strData,"(?<Q>\d+\..+)\n[\s\S]+?\n(?<A>Answer.+)")

Sample20231109-5L.zip (3.2 KB)

Regards,

[Beginner1234]

Hi @Yoichi , i will check this and let you know.

[Dinesh_Guptil]

Hi @Beginner1234

Can use this syntax

[rlgandu (Rajyalakshmi Gandu)]

@Beginner1234

System.Text.RegularExpressions.Regex.matches(strData,“\d+.[A-Z \d a-z]+?|Answer\s:.”)

Use for each

In that use append line activity. To append the matches

[lrtetala (Lakshman Reddy)]

Hi @Beginner1234

Try this

"(?=\d+\.\s+).*|(?=Answer).*"

O/P:

Hope this helps!!

[Beginner1234]

Hi @Yoichi , tried this code for another set of questions but it’s not giving output below are the questions

[Beginner1234]

Hi @lrtetala if possible can you share me the code.

[Beginner1234]

Hi @Dinesh_Guptil getting below error

[Yoichi]

HI,

Can you try the following sample?

mc = System.Text.RegularExpressions.Regex.matches(strData,"(?<Q>\d+\..+)\n[\s\S]+?\n(?<A>.*Answer\s*:.+)")

Sample20231109-5L (2).zip (3.7 KB)

Regards,

[Beginner1234]

Thanks @Yoichi it worked. Small doubt can I use same regular expression for word document also. I’m getting both .txt files and word documents.

[Dinesh_Guptil]

@Beginner1234

Use Matches instead of match

[Yoichi]

Hi,

How are you planning to extract text from Word document? (ReadText activity?)
There is difference regarding linebreak between text and docx. Can you share a sample file of docx?

Regards,

[Beginner1234]

@Yoichi for word document we need to use word document activities right.

Sample Word Document.docx (12.5 KB)

This is the sample file

[Yoichi]

Hi,

Which ReadText activity do you use, System-File-WordDocument-ReadText or ReadText with WordApplicationScope?

If Former the above regex will work as it is.
If latter it’s necessary to modify regex pattern because of linebreak.

Regards,

[Beginner1234]

Sure @Yoichi Thanks i will try this.

[Yoichi]

Hi,

FYI, the following pattern will work for text from text file and both word activities.

mc = System.Text.RegularExpressions.Regex.matches(strData,"(?<Q>\d+\..+)[\n\r]+[\s\S]+?[\n\r]+(?<A>.*Answer\s*:.+)")

Sample20231109-5L (3).zip (13.9 KB)

Regards,

[Beginner1234]

@Yoichi this code is working fine with Text file and for word file it’s writing me as it is from input file

[Yoichi]

Hi,

Sorry but the above pattern is not very good.
Can you try the following?

mc = System.Text.RegularExpressions.Regex.matches(strData,"(?<Q>\d+\.[^\n\r]+)[\n\r]+[\s\S]+?[\n\r]+(?<A>[^\n\r]*Answer\s*:[^\n\r]+)")

And show Q and A separately.

Sample20231109-5L (4).zip (14.0 KB)

Regards,

[Beginner1234]

Thanks @Yoichi it’s working perfectly. Thanks for your help.