DSXchange

Craig,
Found the issue, Both index(),position and Ray's code were working fine. Issue was, there was an EM dash and dash between the description. Replaced the em dash with single dash and now it worked.

Just found one more thing, for only 3 - Marketing client or 4 - Human resource , both the codes were working fine.

Now we got different codes as well such as BA 100 - Outgoing call, CC 203 - Call center.

In this case, it is only picking up , BA and CC instead of BA 100.

It worked......Thanks Craig and Ray..

Ray, Thanks. as I posted earlier. My premium membership got expired and already renew in process. Can't see the code. Unlocking the code for a while would be really helpful.

Craig. Thanks. My membership is still inactive though renewed last week, unlock it for few minutes would be great

All, Need a help in date conversion. I searched quite a bit but could not find the specific conversion function. My input is from DB2 and data type is DATE which is YYYY-MM-DD for format. The output is in sequential file (.txt) and it needs to be MM/DD/YYYY format. I used the below function, but not...

Thanks Ray and Craig.. Appreciate your help. I tried both and both worked.

All, Have an issue with the substrng function in server job. I three columns coming from several DB2 inputs. All having date, description and count. Like, Date Count Customer_cd 11-10-2014 125 3- Marketing client I need to have only 3 instead of 3- Marketing client. The code may change so cant use s...

Craig, Sorry for the late reply. I found the issue and solved it. The problem was, the input is in DB2 and datetime is in GMT. So, when any phone call comes in after 12.AM, it was taking the next day instead of current day. But technically it is current day not next day. I used an IF function in tra...

All, Need a help in DATE issue in server job. We have two columns which are creating the issue due to day light saving. Call_Attend Call_Ended 2014-11-05 11.55PM 2014-11-05 11.59PM So, these two input columns should have the same date. Now for time change some of the records inserted as, Call_Attend...

Opps..Did not know that.. Just thought to ask as something while looking the threads I miss the functions between parallel and server.

Thanks Craig. That is always true. Spoon feeding is not at all a good practice. Do we have field function in server jobs. I thought it is in parallel only.

All, Need suggestion on splitting one columns to multiple. I have one column like: Column1 12:10:07: Dialing 12:10:07: Connecting 12:10:07: ABC: abc:9433769782$100.88.77.0:8787 12:10:09: ABCD: 0000 How can we split the column into two columns. Can we use any substring function. Column 1 (Time), Colu...

Ok. Thanks Craig. We changed the source file.

Thanks again

Craig. Thanks. That's what i thought. There is no delimiter. It has always been a fixed width length file. There was a change in source system. After that we are getting the file like that. The problem is in the last column where the change occurred. Column looks like, SS01012005PP which is char(12)...