# Extracting text into columns

I have a set of customer reports, each is in ms word file. they are all in a similar pattern, for example they start with Name: --, Age: --, Date: --, etc...

is there a way to extract particular strings from each file to form a data set.

In orange, I was able to compile the word documents into corpus which I can display as one column (each report is in one cell). Does orange have a way to extract strings into columns (for example if between "age:" and "gender")?

• I don't know Orange but this can be done easily with a bit of programming. You might be able to do it just with a simple 'grep' tool using regular expressions. – Erwan Jun 13 at 13:58
• thanks for the reply. can you please suggest a simple tutorial/video that goes through the steps? I am actually an R user not python. The only reason I switched to orange/python now is that I was told it handles text much better. – Bahi8482 Jun 15 at 3:45
• there are many ways to use regular expressions with R, but it requires a bit of programming. stringr is a good library. – Erwan Jun 15 at 13:24

(?ix)        # ignore case, ignore comments and whitespace in this RE