Would this be helpful to anyone

[ScottMattes]

The work that I am doing now requires much breaking apart of fields into their component pieces - say an 80 character order of 20 fixed fields.

How about a plug in that you could invoke to parse that record into predefined chunks? Something like the single record view in the Query Window.

Would anyone need this?

 

[aotte]

Hi Scott,

How is what you are proposing different than dragging the Columns folder of a table/view from the browser into the edit window?

 

[ScottMattes]

Hi Arnoud!

I have rows in tables that contain a field that has information that has been 'squished' together. We don't parse it out into fields of a table for various reasons. So we might have something like this

MATTESWI1907GREENLEFT00018921A

and broken out for easier reading it would be

last name = MATTES
state = WI
birthyear = 1907 (no, I was not born then)
color eyes = GREEN (no they are not)
handed = LEFT
children = 1
deduction = 89.21
period = A

What I propose is a plug-in that you could call up to do that parsing for you.

 

[aotte]

Originally posted by ScottMattes:
I have rows in tables that contain a field that has information that has been 'squished' together.
What I propose is a plug-in that you could call up to do that parsing for you.

Ah, OK, kitchen sink fields.

I guess I would write a view to do that. Seems to provide more flexibility and shareability. Maybe an easy-to-use add-in to generating view DDL would be nice. I don't run into this situation often though.