Hi guys!
Hope you can help me with this one:
- I have a huge MS Access table.
- One of the columns is free text; let's call it "FreeTextColumn".
- Each cell in FreeTextcolumn is free text, and contains either 0 or 1 email address.
- If there is 1 email address, I need to extract it from the free text and copy it to the adjacent cell, in the "EmailColumn").
- the email string ("name@domain.xxx") will always start on a new line and that line will only contain the email address.
For example, if a cell in the FreeTextColumn looks like this:
"Mr Pink
46 years old
likes chocolate
[some other random amount of comments]
pink@panther.com"
Then the adjacent cell in "EmailColumn" should look like this:
"pink@panther.com"
Anyone has an idea how I can do this ?
Maybe thanks!!!
Patrick.
Hope you can help me with this one:
- I have a huge MS Access table.
- One of the columns is free text; let's call it "FreeTextColumn".
- Each cell in FreeTextcolumn is free text, and contains either 0 or 1 email address.
- If there is 1 email address, I need to extract it from the free text and copy it to the adjacent cell, in the "EmailColumn").
- the email string ("name@domain.xxx") will always start on a new line and that line will only contain the email address.
For example, if a cell in the FreeTextColumn looks like this:
"Mr Pink
46 years old
likes chocolate
[some other random amount of comments]
pink@panther.com"
Then the adjacent cell in "EmailColumn" should look like this:
"pink@panther.com"
Anyone has an idea how I can do this ?
Maybe thanks!!!
Patrick.