DSXchange

arunkumarmm

Wait a sec, I have a different idea. When you say your delimiter is of more than one character, does it imply 2 identical characters or different values. For example, do you see 'ThisbbIs ... Sai, Thanks for your reply! I dont have any specific delimiter. I want to split the incoming string based o...

arunkumarmm

Or you can use a basic tranformer to use ereplace.

arunkumarmm

The requirement does not specify multiple-character delimiters. ... Ray, I quoted that field fn will not accpet more than one char as delimiter. I'm sorry if that was not clear. As Field fn will not accept more than one char as delimiter, If it is server, I can use the Ereplace and replace that wor...

arunkumarmm

This code should work. Did you try this?

Code: Select all

Nm:Zinman, Dr Bernard (Mount Sinai Hospital, Toronto) 
svLastNm=Field(Nm,",",1) 
svFirstNm=Field(Field(Field(Nm,",",2),"(",1),' ',Count(Field(Field(Nm,",",2),"(",1),' ')+1)

arunkumarmm

From What I know, these are called attributes. For example, Say below is your XML: <Root> <Item ShortName="James" LongName="James Andy" Number="123456" Code="444"> ABCD </Item> </Root> To read the value of the Item tag your XPath should be /Root/Item/text() An...

arunkumarmm

Yes We can handle. Can you be more specific on your requirements?

arunkumarmm

@INROWNUM Well, that will give you the record count so far , and you could write out the previous @INROWNUM on a key change to get the count for a key, but you'll miss the last key group. Also, it only gives you the count in this partition . So, no, there isn't really a way. You could reduce the co...

arunkumarmm

I'm sorry... my bad!

arunkumarmm

:################################################################### :#This script is used to take backups of Datastage jobs and # :#components # :#The script can be added as a scheduled task and can be made to # :#run in specific period of time. # :#It can be used for any project just by providing...

arunkumarmm

You could export the jobs that you want, modify the dsx file to change the ReadOnly flag to 1 and re-import it. However, please keep in mind that this is a manual process and having some jobs as read-only and some without will be a little messy. But by doing this way no one will be able to edit tho...

arunkumarmm

Also check whether the 'Usage' of that field is defined as 'COMP'

arunkumarmm

If I need to move a set of job to a different category, In 7.5 Manager we will have a 'Move To' option. I'm not sure whether we have it in 8.1 or selecting the jobs and dragging it is the only option?

arunkumarmm

Which is the column you have as 'Key' in your XML output stage. If you want to create a XML record everytime your a2 value changes, keep it as 'Key' in your XML stage.

Also do remember that you can only define one repetition element...

arunkumarmm

Also Do remember to keep your "book id" as the repitation element.

arunkumarmm

Field will work only if the delimiter is one character. If the delimiter is more than one, it will take the first character as delimiter

DSXchange

Search found 245 matches

Move jobs to different category