Data Extract from File Questions

[vbell]

I'm trying to use the "Extract from Text File" feature to extract a value to use in response to my clients' quote requests. As a test, I'm using a simple comma delimited text file and attempting to extract a value from it based on the left column - "age." Here's what I'm doing:

1- Naming the Field "Premium"

2- Accessing the file using the Text File Location field.

3- Setting the File format to "CSV"

4- I click "Refresh" and the system displays two columns. I select "Column2"

5- I enter "32" into the "From line that contains" field

Under Advanced I have checked "Remove spaces before or after the field." I have checked "Above word/phrase is a regular expression." I have unchecked "Remove the extracted line from the file."

I check "include the extractor when checking for messages."

When I click on "OK" I get an Exception error as follows:

Exception occured at:
100: unexpected exception thrown in CItemAutoView:: ShowProperSheet.Line:201.
. in CItemAutoview::OnItemEdit
. Line:334.

When I return to the extractor screen my new field is not generated. When I retry I get the same error.

Ultimately, I want to extract text (2 digits numeric - age) from an incoming email; then extract text from the text file which I will use to populate a new email.

Using this technique I should be able to generate specific quotes for my clients.

Does anyone know if this possible?

Thanks,

vbell

[devicode]

vbell,

Yes, you will be able to generate a specific quote based on the information in the lead e-mail message. Send us an email to request the program update to fix the error message that you are getting.

These are the steps that will need to take

1. Install the software update.
   
2. Add the data extractor field called "Premium".
   In the "From line that contains" field add the name of the age field eg [[PersonAge]]
   
3. Make sure that the [[Premium]] field is below the [[PersonAge]] field. If not then use the up arrow on the toolbar to do so.