Jump to content

String utilities - arithmetic and search terms


JJack

Recommended Posts

Hi,

I'm trying to use the string utilities 'search' and 'substring' on some data (it's an incoming email, to log a ticket).
I'd like to be able to find particular places, eg the occurrence of some delimiting text, perhaps a dash (-) and a colon (:), via Search, into result references say stringUtilsSearchA and stringUtilsSearchB
and then use them to find my next text of interest, eg a stringUtilsSlice populated by a 'from' like &[global["flowcoderefs"]["stringUtilsSearchA"]["result"]] and a 'to' like &[global["flowcoderefs"]["stringUtilsSearchB"]["result"]]

This works after a fashion, but I'd want to get rid of extra spaces or punctuation. I've tried putting my search term in quotes, eg ' : ' or " : " but that doesn't work.
Is there any way to do arithmetic? eg effectively &[global["flowcoderefs"]["stringUtilsSearchA"]["result"]] + 3

Some of my data from the email body is in a table and although searching for literals in it gives me results (positions), when I put those in as from/to values, it returns text that doesn't actually exist. If I recreate it as text only, it finds the wrong bit of the email (although now it is something that exists in the email). Is this to do with it being multi-line, or something else? Are there any good ways of handling line breaks in multi-line text, or indeed table formatting?

Is there a way to get an incoming email 'attached' to the call it logs?  (My service manager routing rule template has Add Attachments set to Yes but that doesn't seem to be effective for this, I see from the documentation it just refers to attachments to the incoming email itself). The formatting of the incoming email when it is used as the content (description) of the call leaves far too many blank lines.
Sorry for long post, hope someone can help.

 

Link to comment
Share on other sites

2 hours ago, JJack said:

This works after a fashion, but I'd want to get rid of extra spaces or punctuation. I've tried putting my search term in quotes, eg ' : ' or " : " but that doesn't work.

I'm not sure if this is of any help for your question about searching for a particular string. I've used the following regex expression to locate some text that follows Name: within a multi-line string.  

(?<=Name:\s).*

The \s represents the space after Name: so that the space is not included in the result.   

I'm using the Regex Substring to achieve this. 

image.png

Link to comment
Share on other sites

2 hours ago, JJack said:

Is there a way to get an incoming email 'attached' to the call it logs?

When a request is raised from an email, the source email is linked in the back end.  Rather than using the request details to search for your strings, you could use this automation to search on the content or body of the originating email.

image.png

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...