<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Extract First , Last and Middle name from a email id. in New SAS User</title>
    <link>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932807#M41936</link>
    <description>&lt;P&gt;Extract First , Last and Middle name from a email id.&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:animeshkumarmardi@gmail.com" target="_blank"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:jackreacher@gmail.com" target="_blank"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:michaelfassbender@gmail.com" target="_blank"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:riteshsinghsainik@gmail.com" target="_blank"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;if no middle name the output will be blank&lt;/P&gt;
&lt;P&gt;E.G-&lt;/P&gt;
&lt;P&gt;First Name- Animesh , Jack&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Middle Name- Kumar ,&lt;/P&gt;
&lt;P&gt;Last Name- Mardi , Reacher&lt;/P&gt;
&lt;P&gt;can we use scan function too on this ?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 18 Jun 2024 14:47:33 GMT</pubDate>
    <dc:creator>animesh123</dc:creator>
    <dc:date>2024-06-18T14:47:33Z</dc:date>
    <item>
      <title>Extract First , Last and Middle name from a email id.</title>
      <link>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932807#M41936</link>
      <description>&lt;P&gt;Extract First , Last and Middle name from a email id.&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:animeshkumarmardi@gmail.com" target="_blank"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:jackreacher@gmail.com" target="_blank"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:michaelfassbender@gmail.com" target="_blank"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:riteshsinghsainik@gmail.com" target="_blank"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;if no middle name the output will be blank&lt;/P&gt;
&lt;P&gt;E.G-&lt;/P&gt;
&lt;P&gt;First Name- Animesh , Jack&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Middle Name- Kumar ,&lt;/P&gt;
&lt;P&gt;Last Name- Mardi , Reacher&lt;/P&gt;
&lt;P&gt;can we use scan function too on this ?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 18 Jun 2024 14:47:33 GMT</pubDate>
      <guid>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932807#M41936</guid>
      <dc:creator>animesh123</dc:creator>
      <dc:date>2024-06-18T14:47:33Z</dc:date>
    </item>
    <item>
      <title>Re: Extract First , Last and Middle name from a email id.</title>
      <link>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932858#M41937</link>
      <description>&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/430763"&gt;@animesh123&lt;/a&gt;&amp;nbsp;wrote:&lt;BR /&gt;
&lt;P&gt;Extract First , Last and Middle name from a email id.&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:animeshkumarmardi@gmail.com" target="_blank" rel="noopener"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:jackreacher@gmail.com" target="_blank" rel="noopener"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:michaelfassbender@gmail.com" target="_blank" rel="noopener"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:riteshsinghsainik@gmail.com" target="_blank" rel="noopener"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;can we use scan function too on this ?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;NO. SCAN function would require one or more delimiter characters to separate the pieces such as the period in &lt;A href="mailto:John.Smith@something.com" target="_blank"&gt;John.Smith@something.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;With your examples including multiple sources guessing any rules for name pieces is going to be difficult at best.&lt;/P&gt;</description>
      <pubDate>Tue, 18 Jun 2024 15:11:01 GMT</pubDate>
      <guid>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932858#M41937</guid>
      <dc:creator>ballardw</dc:creator>
      <dc:date>2024-06-18T15:11:01Z</dc:date>
    </item>
    <item>
      <title>Re: Extract First , Last and Middle name from a email id.</title>
      <link>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932864#M41938</link>
      <description>&lt;P&gt;I don't think you can use traditional programming here. If you're using an LLM (OpenAI or a self served model) you'll have better luck.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Pasting your question into ChatGPT shows responses which seem reasonable.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;LI-SPOILER&gt;
&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/430763"&gt;@animesh123&lt;/a&gt;&amp;nbsp;wrote:&lt;BR /&gt;
&lt;P&gt;Extract First , Last and Middle name from a email id.&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:animeshkumarmardi@gmail.com" target="_blank" rel="noopener"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:jackreacher@gmail.com" target="_blank" rel="noopener"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:michaelfassbender@gmail.com" target="_blank" rel="noopener"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="mailto:riteshsinghsainik@gmail.com" target="_blank" rel="noopener"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;if no middle name the output will be blank&lt;/P&gt;
&lt;P&gt;E.G-&lt;/P&gt;
&lt;P&gt;First Name- Animesh , Jack&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Middle Name- Kumar ,&lt;/P&gt;
&lt;P&gt;Last Name- Mardi , Reacher&lt;/P&gt;
&lt;P&gt;can we use scan function too on this ?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;/LI-SPOILER&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;ChatGPT response:&lt;/P&gt;
&lt;DIV class="group/conversation-turn relative flex w-full min-w-0 flex-col agent-turn"&gt;
&lt;DIV class="flex-col gap-1 md:gap-3"&gt;
&lt;DIV class="flex flex-grow flex-col max-w-full"&gt;
&lt;DIV class="min-h-[20px] text-message flex flex-col items-start whitespace-pre-wrap break-words [.text-message+&amp;amp;]:mt-5 juice:w-full juice:items-end overflow-x-auto gap-3" dir="auto" data-message-author-role="assistant" data-message-id="2548f13c-b26c-46bf-b2db-654505660621"&gt;
&lt;DIV class="markdown prose w-full break-words dark:prose-invert light"&gt;
&lt;BLOCKQUOTE&gt;
&lt;P&gt;Extracting the first, last, and middle name from an email ID is not straightforward because email IDs typically do not directly provide such information. However, if we make some assumptions based on common patterns in email IDs, we can attempt to extract the first and last names. Middle names are not typically included in email IDs, so we won't attempt to extract them.&lt;/P&gt;
&lt;P&gt;Here's how we can approximate the first and last names from the given email IDs:&lt;/P&gt;
&lt;OL&gt;
&lt;LI&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;STRONG&gt;First Name:&lt;/STRONG&gt; Animesh&lt;/LI&gt;
&lt;LI&gt;&lt;STRONG&gt;Last Name:&lt;/STRONG&gt; Mardi&lt;/LI&gt;
&lt;/UL&gt;
&lt;/LI&gt;
&lt;LI&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;STRONG&gt;First Name:&lt;/STRONG&gt; Jack&lt;/LI&gt;
&lt;LI&gt;&lt;STRONG&gt;Last Name:&lt;/STRONG&gt; Reacher&lt;/LI&gt;
&lt;/UL&gt;
&lt;/LI&gt;
&lt;LI&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;STRONG&gt;First Name:&lt;/STRONG&gt; Michael&lt;/LI&gt;
&lt;LI&gt;&lt;STRONG&gt;Last Name:&lt;/STRONG&gt; Fassbender&lt;/LI&gt;
&lt;/UL&gt;
&lt;/LI&gt;
&lt;LI&gt;
&lt;P&gt;&lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;
&lt;UL&gt;
&lt;LI&gt;&lt;STRONG&gt;First Name:&lt;/STRONG&gt; Ritesh&lt;/LI&gt;
&lt;LI&gt;&lt;STRONG&gt;Last Name:&lt;/STRONG&gt; Singh Sainik&lt;/LI&gt;
&lt;/UL&gt;
&lt;/LI&gt;
&lt;/OL&gt;
&lt;H3&gt;Explanation:&lt;/H3&gt;
&lt;UL&gt;
&lt;LI&gt;For &lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;animeshkumarmardi@gmail.com&lt;/A&gt;&lt;/STRONG&gt;, we assume "Animesh" as the first name and "Mardi" as the last name.&lt;/LI&gt;
&lt;LI&gt;For &lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;jackreacher@gmail.com&lt;/A&gt;&lt;/STRONG&gt;, we assume "Jack" as the first name and "Reacher" as the last name.&lt;/LI&gt;
&lt;LI&gt;For &lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;michaelfassbender@gmail.com&lt;/A&gt;&lt;/STRONG&gt;, we assume "Michael" as the first name and "Fassbender" as the last name.&lt;/LI&gt;
&lt;LI&gt;For &lt;STRONG&gt;&lt;A rel="noreferrer" target="_blank"&gt;riteshsinghsainik@gmail.com&lt;/A&gt;&lt;/STRONG&gt;, we assume "Ritesh" as the first name and "Singh Sainik" as the last name (assuming "Singh Sainik" is a compound last name).&lt;/LI&gt;
&lt;/UL&gt;
&lt;P&gt;These assumptions are based on common naming conventions found in email IDs, but they may not always be accurate or applicable universally. Email IDs are generally not designed to provide structured names in a way that software can reliably parse first and last names without additional context or user input.&lt;/P&gt;
&lt;/BLOCKQUOTE&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;/DIV&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 18 Jun 2024 15:51:17 GMT</pubDate>
      <guid>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932864#M41938</guid>
      <dc:creator>Reeza</dc:creator>
      <dc:date>2024-06-18T15:51:17Z</dc:date>
    </item>
    <item>
      <title>Re: Extract First , Last and Middle name from a email id.</title>
      <link>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932883#M41939</link>
      <description>&lt;P&gt;In plain language, write down a set of rules that solves all your cases, without producing false results.&lt;/P&gt;
&lt;P&gt;If you can do that, someone can translate it to code.&lt;/P&gt;
&lt;P&gt;But I can quickly give you examples that show that your task is impossible, like&lt;/P&gt;
&lt;PRE&gt;annemariemaier@mail.com&lt;/PRE&gt;
&lt;P&gt;Is it Annemarie Maier, or Anne Marie Maier? Both are valid in German. In English, think of Emmy Lou vs. Emmylou.&lt;/P&gt;</description>
      <pubDate>Mon, 08 Jul 2024 11:39:02 GMT</pubDate>
      <guid>https://communities.sas.com/t5/New-SAS-User/Extract-First-Last-and-Middle-name-from-a-email-id/m-p/932883#M41939</guid>
      <dc:creator>Kurt_Bremser</dc:creator>
      <dc:date>2024-07-08T11:39:02Z</dc:date>
    </item>
  </channel>
</rss>

