May 26, 201114 yr Hi, Is there anything possible to extract test/numeric values from the word file. i need to extract the similar kind of values from multiple documents. All the documents having same type of pattern.
May 26, 201114 yr That's probably going to be a huge challenge and parsing nightmare. Perhaps you can provide an example? Take a look at 360works' Scribe.
May 28, 201114 yr Author Hi bcooney, I try with the 360 works scribe plugin. I need to extract Name, Contact No and Address from CV and save this values according to the fields given. ie., Name into Name field, Contact No into Contact No field and Address into Address Field. I extract these values using 360 scribe plugin using Regular expressions. But, how I get these values into particular field.
May 28, 201114 yr I'll move this into the 360 forum, and we'll see if they post a comment or suggestion.
May 31, 201114 yr Author I'll move this into the 360 forum, and we'll see if they post a comment or suggestion. Hi bcooney, Is there any comment or suggestion from 360 forum... please
May 31, 201114 yr This can be done pretty easily with scribe if your word document uses content control fields. If it doesn't you will need to extract the entire contents of your document and then do regex parsing with scribe and filemaker text functions. I extract these values using 360 scribe plugin using Regular expressions. But, how I get these values into particular field. If you've already done the regex parsing to get the parts of the text that you want then you can just use the Set Field script step as you normally would to set it to the field you want to store the value in. If your varible $result has the value you want from Scribe then you can just do Set Field [Myfield; $result].
June 1, 201114 yr Author This can be done pretty easily with scribe if your word document uses content control fields. If it doesn't you will need to extract the entire contents of your document and then do regex parsing with scribe and filemaker text functions. If you've already done the regex parsing to get the parts of the text that you want then you can just use the Set Field script step as you normally would to set it to the field you want to store the value in. If your varible $result has the value you want from Scribe then you can just do Set Field [Myfield; $result]. Hi Smef, I'm using the Keywords as $Field. These vales containing some other table. First i extract values from word document to one edit box. and extract based on keywords given using this script. In that CV Name : AAAAA Father’s Name : XXXXX Date of Birth : 12-12-2050 Marital Status : Single Gender : Male Here Name, Father's Name, Date of Birth, Maritial Status, Gender are the key words. Using loop concept the keyword is chaned based every loop. The Script is, Set Variable [$result; Value:ScribePatternMatchAll (Employee_details::Import; "^\s?"&$Field&"(\s*)+:?(\s*.*?)(?:#|$)")] It is extract based on keywords given. My problem is Every CV there is Keywords are different. How to i rectify this. Anything possible without using keywords.
June 1, 201114 yr You could use regex to look for " : " if every document is formatted in that way and then check for text around it, but if formatting is different between documents and you don't know what values you're looking for I think it would be very difficult to write regex to parse the information out.
June 3, 201114 yr Author You could use regex to look for " : " if every document is formatted in that way and then check for text around it, but if formatting is different between documents and you don't know what values you're looking for I think it would be very difficult to write regex to parse the information out. Is there any other possible option to extract values...
June 3, 201114 yr If you don't know what you want to extract, what format it is written in, or where it is in the document it becomes very, very difficult to write a method of text parsing. If you knew the 10 (let's say) sets of text you wanted to look for it would be much easier, but with what you're saying it sounds like a difficult parsing task.
Create an account or sign in to comment