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...
Pipelines
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
    ------------------------------