Derived fields

[Niru]

Hello All,

How create 3 new derived fields using below commentary. any Suggestions please.

data

Name1: Due to the manual nature of this process, Bankers are not scanning the Affidavit of Validity for POA, required supporting documentation (POA) and the Principal/Agent name does not match the legal documents or is misspelled. Name2: Branch Process Project initiative is underway to centralize the review of all complex account types. Phase 1 approach includes POA and Rep Payee and target implementation is by Q2-2021. Implemented additional banker education to improve knowledge through KA (Knowledge Assessment) in October 2020 and ICSC (internal control self-checklist) scheduled for January 2021. Name3: 01-02-2021

Expected Output
Name1	Name2	Name3
Due to the manual nature of this process, Bankers are not scanning the Affidavit of Validity for POA, required supporting documentation (POA) and the Principal/Agent name does not match the legal documents or is misspelled.	Branch Process Project initiative is underway to centralize the review of all complex account types. Phase 1 approach includes POA and Rep Payee and target implementation is by Q2-2021. Implemented additional banker education to improve knowledge through KA (Knowledge Assessment) in October 2020 and ICSC (internal control self-checklist) scheduled for January 2021.	1/2/2021

[AngelosPachis]

Hi @Niru ,

You can do that with a regex tool, keeping everything that comes after Name 1,2 or 3

Hope that helps,

Angelos

[Niru]

@AngelosPachis  Thanks for reply, i tried to implemented same logic its not working as excepted kindly suggest me. 

[afv2688]

Hello @Niru ,

This may be a little overkill but it works 🙂

Regards

[Niru]

@afv2688 i have attached workflow i have tried to implement same its not working. Any suggestions please 

[Niru]

Any suggestions please 

[afv2688]

Hello @Niru,

This is what I have been able to do for now.

Check it out and let me know your thoughts.

Regards