DSXchange

Hi,

We usually use Pipe seperated sequential file.

In this case we have source data containing both pipe and comma.

i tried different options available as delimiter in sequential file but nothing seems to work.

I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.

Help on this is appreciated on this.

Why do you believe that the Sequential File stage does not allow using Ctrl-Y as the field delimiter? How have you tried to enter that value into the Field Delimiter property?

ray.wurlod wrote:Why do you believe that the Sequential File stage does not allow using Ctrl-Y as the field delimiter? How have you tried to enter that value into the Field Delimiter property?

Yes i tried.

For Ctrl-Y i have to type in char(25)

And the delimiter allows only one character there.

Please help.

Next time you're in that screen read the help on entering ASCII codes for non-printing characters.

Does this post relates to which case?
Thanks

highpoint wrote:And the delimiter allows only one character there.

Use the property "Delimiter string" instead of Delimiter.

Delimiter string allows for multiple characters.

Here's the thing - all they have is a single character, hence Ray's advice to read the help and learn how to input them when they are "non-printing".

Craig

I am not able to understand without sample data.
How pipe and comma becomes single non printing character ?
Can you Please post some sample data with the delimiters what this thread is being discussed?

highpoint wrote:I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.

Pandeesh, we're responding to this statement.

ray.wurlod wrote:Next time you're in that screen read the help on entering ASCII codes for non-printing characters.

I read the ascii help on this.

And i tried using the delimiter string option in format tab of sequential file.

I tried using char(25) , 'char(25)'

But i dont see Ctrl-Y in the output of my file.

Please help.

ray.wurlod wrote:something that was moved to another thread.

Would appreciate reply on my question.

Looks like my thread is being hijacked. :D

Un-hijacked. And your answer can be inferred in what Ray wrote to the hijacker.

I have tried using 025, 222 for all this it fails with the following error:

DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222


When i use char(222) or @FM then the job runs fine but the data on unix shows char(222) or @FM instead of special character respectively.

I am trying to come up with a standard for using delimiting character which we can use in all the sequential files without worrying what our data may contain.


Would really appreciate your help on this.

highpoint wrote:I have tried using 025, 222 for all this it fails with the following error:

DST_BenefitPlanLoad_MBR_PAY_DSGN_STEP_SUM_DIM_ins: Error when checking operator: "delim_string" property must have a string value; text: delim_string=222

You should be entering that as the Delimiter property, not the Delimiter String.

How about asking the source system to send you the field in which you are expecting pipe,comma as data itself in quotes(single, doulbe etc).
eg.

A|B|"C|"|D