Pipeline to Pull information from an Outlook Subject

Question

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.&nbsp;
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------------------------------

jeffpeterson1 · Answer

Which field holds the vendor name?&nbsp; And is the formatting of that field consistent?&nbsp; &nbsp;
I'm thinking you can do this with a regular expression.------------------------------Jeff Peterson------------------------------

carlsnodgrass · Answer

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],"-");
&nbsp;
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------------------------------

Forum Discussion

Pipeline to Pull information from an Outlook Subject