Text Expression

  • Thread starter Thread starter V_Ernst
  • Start date Start date
V

V_Ernst

I am working on a query and I have a field called "Internet Address". The
contents of the "Internet Address" contain a combination of a user id and a
"/" followed by an email address.
Example:
AB123456/[email protected] or ABXY123456/[email protected]

I would like to write an expression to pull the two items apart so in one
column I have just the user id of "AB123456" or "ABXY123456" and another
column that would just contain the email address "(e-mail address removed)"

I realize I may have to write two expressions to return the items in
seperate columns which is perfectly fine.

I have about 600 accounts where I need to split the USER ID from the EMAIL
Address.
 
Try these --
Left([Internet Address], InStr([Internet Address],"/")-1)
Mid([Internet Address], InStr([Internet Address],"/")+1)
 
I had to correct the syntax for Internet Address. The field is actaully
Internet_Address.

Another question, some of 600 accounts I have are blank since they don't
have accounts yet for this particular set up. So I need to give consideration
for "Null" that gets returned when there is no data in that particular field.

So both for the ID and the email address i need to recongnize blanks

Otherwise your formula worked fine!

--
V_Ernst


KARL DEWEY said:
Try these --
Left([Internet_Address], InStr([Internet_Address],"/")-1)
Mid([Internet Address], InStr([Internet Address],"/")+1)

--
KARL DEWEY
Build a little - Test a little


V_Ernst said:
I am working on a query and I have a field called "Internet Address". The
contents of the "Internet Address" contain a combination of a user id and a
"/" followed by an email address.
Example:
AB123456/[email protected] or ABXY123456/[email protected]

I would like to write an expression to pull the two items apart so in one
column I have just the user id of "AB123456" or "ABXY123456" and another
column that would just contain the email address "(e-mail address removed)"

I realize I may have to write two expressions to return the items in
seperate columns which is perfectly fine.

I have about 600 accounts where I need to split the USER ID from the EMAIL
Address.
Click to expand...
Click to expand...
 
Back
Top