Forum Discussion

GZRService_Acco's avatar
GZRService_Acco
Qrew Trainee
3 months ago
Solved

Pulling Number out of a string

I am trying to pull out a record ID # from an email subject or email body. I want: Input -     Re: 4793 - New Ticket -... Output - 4793 Or Input -  Should be handled by: Maintenance Recipients...
Pipelines
  • GZRService_Acco's avatar
    GZRService_Acco
    3 months ago

    I ended up using a splice to take the first 8 characters minus the first 4.  It won't work on old tickets, but tickets moving forward will work.

    Thanks.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 months ago

This can probably be done just with a QuickBase formula. Can you tell me if the format is always the same? For example, if we look for the phrase "Re:" in the subject line, can we be sure that will be there and the following characters will be the number you are looking for?  

 

Then the same for the body content. Can I look for the phrase? Ticket #: and pull out the number following?

  • GZRService_Acco's avatar
    GZRService_Acco
    Qrew Trainee
    3 months ago

    Yes, the formatting will always be the same.

    Unfortunately, I can't do with a Quickbase Formula.  I'm trying to tie these responses to existing QB records, not create new ones.