DSXchange

Sorry, no. Read the help for the Count() function. Or better yet, build a test harness routine in the Manager and try it out for yourself. ... ok, let me put in this way for example i have string "aaa bbb ccc dd ee ff" what i am expecting is a count of 6 in other words aaa bbb ccc dd ee 1...

chulett wrote:How to count number of substrings in a string? Count()
How to find the starting position of the string? Index() ...

It give the number of charecters not the number of substrings

How to count number of substrings in a string?
How to find the starting position of the string?

ex:"How to count number of substrings in a string"

Thanks in advance

Job design

seq1------|
seq2------|------->linkcollector-->seq4--->sortstage--->seq5
seq3------|


I am sorting the data by key column,i am expecting to get the data in sorted format but When i look at the data in seq5 the key column values are same.

any ideas

From lookup. Hi, Lookup data (Hashed File) 123456@10@b 123456@00@c Source data ( Hashed file) 123456@00@c I need to delete both the records from hash file if the first 6 positions are same. Any advice. Thanks in advance Hello HELLO (God!! I feel stupid), Delete both records from WHICH hashed file? Y...

Hi,

Lookup data (Hashed File)

123456@10@b
123456@00@c

Source data ( Hashed file)

123456@00@c

I need to delete both the records from hash file if the first 6 positions are same.

Any advice.

Thanks in advance

Job Properties 1. Check the box -- Allow Multiple instance 2. Set the Parameters as below: Parameter name Prompt Type Default Value BeginRec Enter Begin Row string 1 EndRec Enter End Row String 30000 BeginRec1 Enter Begin Row string 30001 EndRec1 Enter End Row String 60000 ... 3. When we set it to m...

1. First check for the credit card number(CC_NO)

sv1 If LEN(Trim(CC_NO,' ','A')) = 16 Then @True Else @False

2. Then check for mod 10.

sv2 If Mod(Trim(CC_NO,' ','A'),10) = 0 Then @True Else @False

3. Constraints sv1 and sv2

Good Luck

It should not be problem, if you are accessing it.

Can you go a head and give more information.

Try this logic:

Create three stage variable

sv1 Iconv("01/03/1968", "D2/")
sv2 (@DATE - sv1)/365
sv3 IF sv2 > 16 AND sv2 < 85 Then @True else @False

Good luck

Hi,

Is there any Universe query to find out Hashed file size in terms of GB.

Thanks in advance.

Hi,

I am using a ORAOCI9 stage, where i am performing an insert and update, my understanding is we can know how many rows are inserted are updated.

Is there a way to know in a particular row which column is updated
or
which row is inserted.

Thanks in advance.

DSguru2B wrote:Use the query in this link. This will give you the job name which will create and read this file. If you just want the job name that will create the file then remove 'CSeqOutput' from the query.

I am not sure how to implement this, can let me know where i need to write this query.

Thanks

Hi,

How can we know which job is going to create a particular sequential file.


Thanks

I didn't get your point. you said Trim() never removes the last of any set of internal spaces. But Trim(Link.Column," ","A")="" can removes the internal spaces right???......Thats the reason I used it in my Jobs..... If not Please explain. Thanks in advance. If ISNULL(...