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