Sign in to follow this  
Followers 0
brucejohn22

Help with filtering data that is not needed

7 posts in this topic

Please help :)

here is my code:

#include <IE.au3>

$oIE = _IEAttach ("site name")

$oForm = _IEGetObjById ($oIE, "MainForm")

$oRCDEmail = _IEGetObjById ($oForm, "RCD_cboEmail") ;customer email

MsgBox( 0, "Form Element Value", _IEFormElementGetValue ($oRCDEmail))

Here is what I get: 10000|sample.email@email.com|10

10000 = the number email I am in the data base

sample.email@email.com = actual email address

10 = the type of email

I think the problem lies more with the site because it has hidden data that appears with this email address I would like to know if there is a way to pull the email address with out the other data. Is there any way to do this please if you can point me in the right direction or give me an example I would greatly appreciate it.

Share this post


Link to post
Share on other sites



Please help :)

here is my code:

#include <IE.au3>

$oIE = _IEAttach ("site name")

$oForm = _IEGetObjById ($oIE, "MainForm")

$oRCDEmail = _IEGetObjById ($oForm, "RCD_cboEmail") ;customer email

MsgBox( 0, "Form Element Value", _IEFormElementGetValue ($oRCDEmail))

Here is what I get: 10000|sample.email@email.com|10

10000 = the number email I am in the data base

sample.email@email.com = actual email address

10 = the type of email

I think the problem lies more with the site because it has hidden data that appears with this email address I would like to know if there is a way to pull the email address with out the other data. Is there any way to do this please if you can point me in the right direction or give me an example I would greatly appreciate it.

StringSplit with the delimiter "|" is the easiest. Also you could do StringRegularExpressions, but that's alot harder...

Share this post


Link to post
Share on other sites

StringSplit with the delimiter "|" is the easiest. Also you could do StringRegularExpressions, but that's alot harder...

Should it look something like this? Or am I way off base:

$oEmailSend = _StringSplit ($oRCDEmail, "|")

Share this post


Link to post
Share on other sites

StringSplit is a built in function. No underscore. You were calling it correctly otherwise.

$oEmailSend will equal the array [3, "10000", "sample.email@email.com", "10"] in your example here.

Share this post


Link to post
Share on other sites

StringSplit is a built in function. No underscore. You were calling it correctly otherwise.

$oEmailSend will equal the array [3, "10000", "sample.email@email.com", "10"] in your example here.

Thank you for the help so far but I know I am not doing something right or maybe I just don't have the right grasp on this. I am so confused. Any one have any examples they could point me to?

#include <IE.au3>

$oIE = _IEAttach ("site name")

$oForm = _IEGetObjById ($oIE, "MainForm")

$oRCDEmail = _IEGetObjById ($oForm, "RCD_cboEmail") ;customer email

$oSplitEmail = StringSplit ($oRCDEmail, "|")

MsgBox( 0, "Form Element Value", _IEFormElementGetValue ($oSplitEmail)

Share this post


Link to post
Share on other sites

StringSplit returns an array so to get the elements you would have to use oSplitEmail[0] etc.

Share this post


Link to post
Share on other sites

$oRCDEmail = _IEGetObjById ($oForm, "RCD_cboEmail") ;customer email

$oSplitEmail = StringSplit ($oRCDEmail, "|")

This won't work. You can't call a string function on an object like that. You need to get the value from the object, then perform a string split on that.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0