Hi Doug, Many may thanks to you for helping on this, this is working very fine
Regards Praveen On Wed, May 22, 2013 at 12:28 AM, Mueller, Doug <[email protected]>wrote: > Praveen, > > Couldn't you just use the same idea > > SUBSTR($Subject$, STRSTR($Subject$, "=") + 1) > > This results in the string of everything past the equal sign. > > Then wrap that in LTRIM and RTRIM to trim spaces > > LTRIM(RTRIM(SUBSTR($Subject$, STRSTR($Subject$, "=") + 1))) > > Note, this takes advantage of the fact that SUBSTR with no third parameter > means to go to the end of the original string. > > Does this get you what you need? > > Doug > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Praveen Tiwari > Sent: Tuesday, May 21, 2013 4:49 AM > To: [email protected] > Subject: Parsing problem > > Hi List, > > I have a small request where i want to parse the following from below > input line: > > Subject: 000000001946766 update "Ticket Priority" = Urgent > > I am able to parse the ticket number 000000001946766 from above by below > function: > SUBSTR($Subject$, STRSTR($Subject$, "[") + 1, STRSTR($Subject$, "[") + > 15) > > Now i want to get value Urgent in any temporary field. if its written like > above > > Can some body help on this. > Thanks > > Regards > Praveen > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
