Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Exactract the values from Word file

Featured Replies

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.

That's probably going to be a huge challenge and parsing nightmare. Perhaps you can provide an example? Take a look at 360works' Scribe.

  • 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.

I'll move this into the 360 forum, and we'll see if they post a comment or suggestion.

  • 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

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].

  • 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.

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.

  • 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...

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

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.