DSXchange

Here is the reworked code. I am using Locate instead of Index. *Use this function to lookup for a value within select values * e.g: SelectCase(LookupValue, "A|B|C", "1|2|3", DefaultValue) Equate RoutineName To 'SelectCase' Equate Lookup To Arg1 Equate InputArray To Arg2 ; ! A|B|C...

I will redo the code and post it again. Thanks,

I've made those changes in my code. Thanks, Also, when I do the following: Pos = DCount(InputArray[1,Index(InputArray, Lookup, 1)], "|") If the variables are InputArray = CARD|CAR|CA and Lookup = CA The previous code is going return the first position, but I would like it to return the thi...

I just did exactly that. but didnt seem to remove the formats.

You already spelt out the specs, so it wasnt that difficult to modify the existing function. However if I am going to create my own function, why not somewhat easier format of arguments instead of those awkward A=1... etc. Here is the function: * Use StringDecodeX(LookupValue, LookupString, ReturnSt...

Ray, Pardon me for being a pain, but your solution wont work for me. I have 20 products in my table which I am trying to transform into six different values. Five of these 20 products will transform into five different types and the remaining 15 will translate into the sixth type. There is no way I ...

I am not looking for an occurence of a pattern. I am sorry if my example misled you. I am looking for a neater way, instead of multiple if conditions. Something like Evaluate statement in Cobol or Select case in SQL. StringDecode does that, but i am not able to specify an "Anything Else" c...

I am trying to use stringdecode routine in one of my transforms. I am using this routine in order to avoid using multiple if statements. Is it possible to use a default condition when using stringdecode routine? that is if I want to say if A = 1, then 10, if A = 2, then 20, if A = 3 then 30 if A = a...

That was fast!.

Let me try the second one first. Thanks!

Hello all, I have one ODBC input stage, one hash file stage used as reference lookup and another OCI8 reference lookup stage. I want to look up key values from the hash file and then pass that key value to the other reference lookup stage to get further detail. Is this possible at all? I am not able...

When I first posted the message, I had one Output link with Update action set as 'Update existing rows and Insert new rows', but could not get it to retrieve the IDX for rows that already exist. As soon as I post, I saw this other posting where it was suggested that we can setup two Output links, on...

I do understand the benefits that hash files offer and I am hoping to start using it as early as next week. About the 'insert after update' you mentioned, What I am doing currently is I have a reference table to lookup for the existence of the row. I have two Output OCIs setup for the same table one...

a) Few reasons why I am not using Hash. i) this is our first project and i dont want to start on hash files right away. ii) The tables I am working currently are not that that big - about 1000 records at the most. iii) This is a migration project and in most cases the record dont exist in the target...

Hello all, I have a table which contains unique addresses. For the sake of simplicity, let me assume that there are only three fields in this table. LocationAdd1, LocationCity, IDX. This table is keyed by Identifier (sequential no) field IDX. I am loading this table with 'Update existing rows or ins...

Oops.. It is working fine. I deleted the variable and recreated again and mapped the derivation and it is fine now. May be I made a mistake last time...
Sorry about that...