OT: HELP PLEASE! MS Access Trim Statement
I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: HELP PLEASE! MS Access Trim Statement
#ListGetAt('[EMAIL PROTECTED]', 2, "@")# Todd Ashworth -- Web Application Developer Network Administrator Saber Corporation 314 Oakland Ave. Rock Hill, SC 29730 (803) 327-0137 [111] - Original Message - From: "Troy M. Wussow" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 2:28 PM Subject: OT: HELP PLEASE! MS Access Trim Statement | I am trying to separate an e-mail address from the domain - everything to | the right of the "@" symbol. I have 2 database fields named [Email] and | [Domain] and I am trying to use either a MID or TRIM statement to copy just | the domain information into the [Domain] Field. | | Any suggestions would be greatly appreciated!!! | | Troy Wussow | Web Developer - MIS | National Seminars Group | | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Trim just removes Spaces, nothing else Try; Mid(myEmail,InStr(Email,"@")+1,Len(myEmail)) Note, this will break if there isn't an @ Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
Using Cold Fusion to do it, or in MSAccess itself? If Cold Fusion, here's a cool trick: cfset myUser = ListFirst(emailAddress,'@') cfset myDomain = ListLast(emailAddress,'@') I love using this :) Jeff Beer Senior Programmer Architect Hydrogen Media, Inc (727) 530-5500 x303 [EMAIL PROTECTED] -Original Message- From: Troy M. Wussow [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:28 PM To: CF-Talk Subject: OT: HELP PLEASE! MS Access Trim Statement I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: HELP PLEASE! MS Access Trim Statement
See page 1023 of SYBEX's "Mastering Cold Fusion" book for list of SQL functions and the databases they work with: Concatenate the following functions into a SQL statement with an AS statement and it should work... mLEN = Length(trim(str1)) -- returns the length of the trimed str1 which you can store in mAT = Instr(str1, str2) returns the numerical position in str1 where str2 begins. mKEEP = Right(TRIM(str1), mLEN - mAT) ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Troy M. Wussow [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:28 PM To: CF-Talk Subject: OT: HELP PLEASE! MS Access Trim Statement I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: HELP PLEASE! MS Access Trim Statement
Consider the email address as a @-delimited list and get the first and last member of the list. best, paul At 01:28 PM 2/28/01 -0600, you wrote: I am trying to separate an e-mail address from the domain - everything to the right of the "@" symbol. I have 2 database fields named [Email] and [Domain] and I am trying to use either a MID or TRIM statement to copy just the domain information into the [Domain] Field. Any suggestions would be greatly appreciated!!! Troy Wussow Web Developer - MIS National Seminars Group ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists