DSXchange

I don't see any point where you mentioned grep or that you "finished the task"... should we mark this as a "workaround"?

Shouldn't you be using a "dot" between them rather than a space? Also ensure you have enabled Microseconds in the extended properties for that column.

I've seen this before mining Apache logs and as noted, being a log file I doubt there's any wiggle room here for improvement. Can't hurt to ask, though. :wink: There used to be a Perl-based module in DataStage specifically for handling data of this nature. That might be another option to consider - ...

I am thinking to use to string match and then find a way to load the data by using field function. Or that string match followed by a substring. Once you find the position of an identifying string, like "Event=", seems to me you could find the next space after that position and then pull ...

If you haven't done so already, definitely involve support in this...

Okay. You might want to start with letting us know the specifics of what kind of help you need. Questions are always good, too. :wink: Otherwise these just tend to turn into a bunch of stage variables as you check each rule one by one and then aggregate the results. I'll also add my two cents, havin...

Wasn't worried just about the escaped quotes...

gsbrown wrote:I don't understand why it has the appended \r\n and extra slash characters all throughout the response.

A little lost... not seeing any differences in the expressions on either side of the OR. Is your condition correctly transcribed from the job? :? Never mind the whole concept of what exactly you are comparing the "2 fields" to in the lookup is unknown. Can you make another attempt at expla...

Someone else asked a very similar question recently, let's see... ah, here it is. Not about an EBCDIC file but the basics still apply.

Was wondering much the same things. Also out of curiosity, what exactly is your target?

From when we looked into it, SHA-1 was starting to be found too vulnerable around 2005 and people have "moved on" to SHA-2 and SHA-3. With my current client being a US Government agency, we were "forced" to migrate everything we had from SHA-1 to SHA-2 starting sometime last year.

Apparently not.

Rather than continue to wait and hope someone with the requisite experience comes by, have you involved your official support provider?

Both times executed by the same user?

rschirm wrote:If you need anymore detail on this email me

Or... just ask here.

Yup, have done exactly that in the past, custom sort rules and the whole nine yards. Or add yet another field that will allow your record types to sort 'naturally' and then drop the field at the end.