Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

How do I parse data from one column to many columns with no delimiters?

I have a column with NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN, I want to parse each position as a seperate column. How would one do the data row is not delimited at all?

I would like to do this in ssis... or should it be a clr

%!!|1||NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN|NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN

share|improve this question
4  
Can you clarify the exact output needed please? – gbn Apr 12 '12 at 7:03
You can create derived columns from the source using the SUBSTRING function, although you would have to do one for each output column. – ConcernedOfTunbridgeWells Apr 12 '12 at 8:21
The output require would be as follows NNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN for each positon a new column so p1 =col 1 p2 =col2 p3=col3 etc – megabyte Apr 12 '12 at 22:25
So if the source column is NNNNN, you would be expecting 5 output columns with a value of 'N' for each? Is the length fixed? i.e. is it always 1 character position for each column? – WT_W May 1 '12 at 23:28
@megabyte: I suggest you clarify better what you want. I suspect the question to be closed if others can't understand what you mean. – ypercube May 17 '12 at 6:54
show 2 more comments

closed as not a real question by Nick Chammas, JNK♦ May 27 '12 at 13:45

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

Browse other questions tagged or ask your own question.