- Posts: 21
- Thank you received: 2
Extracting email domain
1 month 4 weeks ago #22471
by Carl
Extracting email domain was created by Carl
Hello
I am working on creating a complex package(workflow) and i need to extract the email domain.
Thank you for your assistance in advance
I am working on creating a complex package(workflow) and i need to extract the email domain.
Thank you for your assistance in advance
Please Log in or Create an account to join the conversation.
1 month 4 weeks ago #22472
by admin
Mike
ETL Architect
Replied by admin on topic Extracting email domain
Hi Carl
I have created a function for you
Var
vEmail: String;
vDomain: String;
begin
Result := True;
vEmail := GetVariable('<LAST EMAIL>');
vDomain := copy(vEmail,Pos('@',vEmail),1000);
setVariable('<EMAIL DOMAIN>',vDomain);
end;
I have created a function for you
Var
vEmail: String;
vDomain: String;
begin
Result := True;
vEmail := GetVariable('<LAST EMAIL>');
vDomain := copy(vEmail,Pos('@',vEmail),1000);
setVariable('<EMAIL DOMAIN>',vDomain);
end;
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
1 month 4 weeks ago #22473
by admin
Mike
ETL Architect
Replied by admin on topic Extracting email domain
You will find more information about script action here
www.etl-tools.com/wiki/aetle/packages/script_action
www.etl-tools.com/wiki/aetle/packages/script_action
Mike
ETL Architect
The following user(s) said Thank You: Carl
Please Log in or Create an account to join the conversation.