Forum Discussion

CarlSnodgrass's avatar
CarlSnodgrass
Qrew Member
2 years ago

Pipeline to Pull information from an Outlook Subject

Hello,

I am looking for some assistance in adding some functionality to a live Pipeline (Attached picture)

I am currently pulling the PO # from a pipeline tag. 

Here is the code {{a.subject[-6:(a.subject|length)]}}

The email is a template that purchasing sends with our internal PO number as the last 6 digits of the email.

I would like to be able to pull the Vendor name from the email as well but my caveat to that is that the vendor names are varying lengths.

Does anyone have any suggestions on how to accomplish this?



------------------------------
Carl Snodgrass
------------------------------
Pipelines

2 Replies

Sort By
  • JeffPeterson1's avatar
    JeffPeterson1
    Qrew Captain
    2 years ago

    Which field holds the vendor name?  And is the formatting of that field consistent?   

    I'm thinking you can do this with a regular expression.



    ------------------------------
    Jeff Peterson
    ------------------------------
    • CarlSnodgrass's avatar
      CarlSnodgrass
      Qrew Member
      2 years ago

      Hey Jeff,

      Sorry for the delayed response.

      I was able to accomplish what I needed by using the following formula text

      var text Temp = Right([File Attachment Name],"-");
       
      var number StartPosition = Length($Temp);


      The file attachment is a standard name from our ERP. So far it has been working as expected.
      I had to write a different pipeline but to read the file attachment vendor name and write it to the proxy field for the "Related Vendor".
      I am learning pipelines so I imagine it can be done in 1 pipeline but it is 2 for now lol
      Left([File Attachment Name],"-")


      ------------------------------
      Carl Snodgrass
      ------------------------------