DSXchange

Ray, thank you very much for your response. It is really noble that you take your personal time to help others. I really can't thank you enough. You have helped me enormously before as well. I ran my file through the USADDR ruleset. The IPUSADD produced by this ruleset for this address is >T so this...

How do I split an address such as:

123Maple Ave

to

123 Maple Ave

Is there a way to do it through GUI or code?

Question 2: How would you add a street type to an address if it is missing? For example, if Qs sees the input pattern as:

^R^

Example address: 123 Maple 1

How would you add 'St' so that the address is?:
123 Maple St 1

How would the following address be parsed?:

123 W 34 1/2 St

QualityStage parses it with the input pattern: ^D^^/^T

I am putting the following override: HN1PD1SN1SN1SN1ST1

I would appreciate any suggestions.

1)How do we use the CONVERT action to parse an address as: 123 Maple A 1 where: 123: HN1 Maple : SN1 A : (Typo! Should be converted to Ave and then ST1) 1: UV1 2)Where in the.PAT file do I add this code? 3)Is there any way to do this through the GUI, that is, the conversion from A to Ave? Thanks to ...

Which is the best way to add Input Pattern overrides? Should we do it through the .PAT file using Pattern Action Language or should we use the GUI and use the Input Pattern tab? It seems to me that, in both cases, the patterns and their interpratations are stored in the .TBL file.

What do you think?

gateleys, how would you call dsjob with a parameter file? Can you give me an example?

It has to be:

-delim ''

Interestingly, "orchadmin dump -help" does not talk anything about -delim. ArndW, where did you find it?

I don't want anything after a field. How do I specify that?

"Orchadmin dump" copies a datset to a sequential file. However, the problem is, by default, it puts a space after every field. Is there any way to adoid that? I would like to copy a dataset to a sequential file as is, that is, the length of all columns should be exactly the same in the dat...

I have a simple job where data is being written from a SQL Server table to a sequential file aftercoming through a transformer. When I view the data from SQL Server on the DRS stage, it looks fine. However, when I display data on the sequential file, it just shows the first 2 columns. What's interes...

Here is my job design: File1 -------> Compare ------> PromoteSubrecord----->SeqFile File2 --------> The output column of the Compare stage has: result tinyint first unknown second unknown The input tab of the Promote Subrecord stage has: result tinyint first unknown second unknown Under stage proper...

By the way, I am extremely disappointed in the Developer's Guide. All it does is describe a stage. It doesn't give any more details and there are very few examples. For example, for the Compare stage, it seems like you are expected to know what result, first and second are and how to use them. No wh...

Ray, I don't see a subrecord datatype. For the output columns of the Compare stage, what would the datatypes be?

diff: integer
source1row: subrecord

1)What is a "subrecord" datatype?

The Guide says that the output columns are result, first and second.

I still haven't been able to resolve this issue. Does anybody have any idea? All my columns are char.