Re: Querying message descriptions

Yeah, I tried an asterisk and got nothing, as I recall - that WAS early this morning, after all!

I put in just the letter a and got a lot. I see that one can use multiple conditions, with contains, hey, only 26 of them, right?

Glad the idea clicked and hope it works for you

Vern

On 12/7/2015 11:58 AM, darren@xxxxxxxxx wrote:

Hey! That's something I hadn't thought of. I knew I could search, but
didn't know about the export to Excel. If I can trick the search into
showing all records, then I can export to Excel. With that I can upload
the Excel to a PF, and then query from that.

Thank you.




From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/07/2015 12:16 PM
Subject: Re: Querying message descriptions
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



iSphere has a message file search feature, and you can export the
results to Excel

On 12/7/2015 10:03 AM, darren@xxxxxxxxx wrote:

Someone asked me for a list of possible messages a program might send. I
compiled a list of about 250 message ID's that refer to a vendors message
file. Is there an easy way to query the message description in a message
file? I'd like to join this list of ID's to the message file to convert
the ID's into descriptions. I've searched and haven't located anything
like a SQL view or service that might help.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.