Jump to content

Help with Removing Email Address Suffix


Recommended Posts

HI -- I have an array with a varying number of rows and 13 columns. In all rows of Col5 I have email addresses in the form of firstname.lastname@emailaddress.com. All email prefexes (firstname.lastname) are unique, and all email suffixes (@emailaddress.com) are the same. I'd like to remove @emailaddress.com from all Col5 rows. So the result will be only the unique firstname.lastname prefexes remaining in their original Col5 rows. I've tried StringTrimRight, StringTrimLeft, and StringReplace, but haven't been successful. My current unsuccessful attempt is below.

For $i = 0 To UBound($aUsers) - 1
   $vStringCut = StringReplace ("$aUsers[$i][5]", "@emailaddress.com", "")
Next

For $i = 0 To UBound($aUsers) - 1
   $aUsers[$i][5] = $aUsers[$i][$vStringCut]
Next

_ArrayDisplay($aUsers)

 

I hope someone can show me how to get this right. Thank you!

Link to post
Share on other sites

I think it should be:

For $i = 0 To UBound($aUsers) - 1
   $aUsers[$i][5] = StringReplace($aUsers[$i][5], "@emailaddress.com", "")
Next
_ArrayDisplay($aUsers)

 

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2021-06-05 - Version 1.5.4.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2021-06-14 - Version 1.6.5.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (NEW 2021-07-28 - Version 1.1.0.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Link to post
Share on other sites
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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...