ETL-Tools.Com

<POP3 Message>

More
10 years 4 months ago - 10 years 4 months ago #7340 by hanisultan
<POP3 Message> was created by hanisultan
I'm interested in extracting the <POP3 Message> variable from an email without the html tags (see attached). How do I accomplish that?
Attachments:
Last edit: 10 years 4 months ago by hanisultan.

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7343 by admin
Replied by admin on topic <POP3 Message>
That is an interesting question.

Although it is possible I personally would ask customer to use plain text

You can use string functions to get <body part> but it is not going to be simple

Mike
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7345 by hanisultan
Replied by hanisultan on topic <POP3 Message>
This is actually a form the customer fills out to provide feedback. The site automatically email the content of the form to our email and I'm trying to use the etl to get the email and parse out the different parts. So we have no control over that.

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7346 by admin
Replied by admin on topic <POP3 Message>
That is actually a good thing because the format is stable

That should be reasonably easy thing to do

Mike
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7347 by hanisultan
Replied by hanisultan on topic <POP3 Message>
What are you referring to when you say "easy thing to do" ?

Please Log in or Create an account to join the conversation.

More
10 years 4 months ago #7348 by admin
Replied by admin on topic <POP3 Message>
Use calculation

Pos function to get position of <body> part
than substring
than ensurenosuffix

There are a lot of string functions you can use

Mike
Mike
ETL Architect

Please Log in or Create an account to join the conversation.

Copyright © 2023 ETL-tools.com. All Rights Reserved.