DSXchange

Let's start by moving this to the correct forum... the 'Dads & Grads' forum was not the proper place for this.

Never having done any "image extraction / manipulation" work of this ilk I'm curious what all might be involved in it. Obviously it's not really an ETL task but knowing the steps / components / utilities involved might help decide how much of a PITA it might be using an ETL tool. Or, if yo...

Let us know.

I've never tried such a thing but I'm sure you do have some options along those lines, especially when running a Windows server. Perhaps via an Excel ODBC driver? And some clever macro work?

Perhaps someone here has been forced to do such a thing and will wander by.

Sorry, just wanted to add that I had hoped you would take the information provided here by folks and apply it to your questions, work things out. This rather than wanting to be spoon fed.

Anywho, see what other questions come to mind now and let us know if you still need help with this.

Check the documentation - I believe that separating them with a single semi-colon makes them individual transactions while 'double semi-colons' means all as one transaction.

You'd need to use something like 'sed' or 'awk'.

Right. Load the csv data into database tables and let your BI Team handle the graphics.

Did.

But just to beat this pony, when you use EReplace() to replace anything with '' (an empty string) you are removing it from the string in question. And yes that includes Field Marks.

1) As noted, to educate yourself. To make them 'visible'. As to your other questions, understand that DataStage returns Command Output in a dynamic array with each line sent as output to the screen as an element in that array. The newlines in the output are automatically converted to Field Marks by ...

Depends on the settings used. Have you checked the score?

Exactly... details would be good.

Why not check with Support, see what the official answer is?

Yup! :D (just don't ask me what exactly each of them are) @TM A text mark, Char(251) @SM A subvalue mark, Char(252) @VM A value mark, Char(253) @FM A field mark, Char(254) @IM An item mark, Char(255) Thought it was kind of obvious that high order values like that weren't really 'displayable' but you...

Ernie, the values are documented in the link I posted.