Single column to multiple

sam334 · Post by **sam334** » Tue Sep 09, 2014 1:12 pm

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.

Code: Select all

Column 1 (Time),    Column 2(Description)
12:10:07:           Dialing
12:10:07:           Connecting
12:10:07:           ABC: abc:9433769782$100.88.77.0:8787
12:10:09:           ABCD: 0000

Thanks and appreciate your help. Source data is coming from sequential file.

chulett · Post by **chulett** » Tue Sep 09, 2014 1:23 pm

Investigate the Field() function which can extract fields from a delimited string. Tell it you have a ":" delimited string and you want the fourth field and all fields after that.

I'd rather you do this on your own rather than simply hand off the syntax as it's a better learning experience that way. Teach a man to fish and all that.

sam334 · Post by **sam334** » Tue Sep 09, 2014 1:30 pm

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.

chulett · Post by **chulett** » Tue Sep 09, 2014 1:35 pm

I wouldn't have suggested it if it wasn't in Server jobs, they were my bread and butter for many years.

sam334 · Post by **sam334** » Tue Sep 09, 2014 2:03 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Sep 09, 2014 5:13 pm

Seems to me (based on your example) that the more appropriate delimiter to use in your Field() function is " " rather than ":".

chulett · Post by **chulett** » Tue Sep 09, 2014 10:58 pm

Sure... assuming it's actually a space. And I thought using the colon as the delimiter would be more illustrative of the function's use.

priyadarshikunal · Post by **priyadarshikunal** » Wed Sep 10, 2014 2:47 am

If the first column is fixed width as it seems from the example, you can try left() and right() functions as well.