DSXchange

Yeah, what a pain. Thats why I ended up using the oconvert, trimf, oconvert again. I still don't know why the Trim is not working as described.

alisoviejo wrote:I had a smilar issue and had to use ltrim inthe Oracle stage (Source) !

No, it's not working. I copied and pasted your code in there, so there is no chance of typing a zero as an O or vice-versa. If it works in yours, it should work in mine, right? Well it's not. Guys trim('000987A87',"0","L") Result = 987A87 has to work with Trim function. Unless th...

Right.

chulett wrote:It's not an integer, but rather an alphanumeric value: "000987A87".

I don't want to eliminate every 0. Only leading 0's. Also, I think ereplace is server only. Right?

er

srikanthd1978 wrote:if u get an alphanumeric value u shld be able to use the 'ereplace' function and eliminate the "0" char in ur string...but i think the trim shld work...

It's an alphanumeric (VARCHAR). 0009321A3 is a valid input, but I'd need the output to be 9321A3

ray.wurlod wrote:What is the data type of MYFIELD? Have you tried converting it to integer (say in a Transformer stage)? That should remove the zeroes - if it doesn't adding zero to the integer definitely will.

I get the same result whether I use single, double, mixed and every combination of quotes that I could think of. This is quite frustrating.

kumar_s wrote:Hi,

Try with the paramteres passed for the Trim function in single quotes.

Code: Select all

Trim(link.field,'0','L')

-Kumar

No, again, that is not working. I get 000987A87 when I copy and paste your code into my job. Are you using a parallel job? I am. Hi The trim function must work. I had used it so many jobs and never had this problem. I used the below to do a quick test to see what the result is. trim('000987A87',&quo...

Using the trim function to remove leading zeroes does not appear to be working. The input value was 00092102A92 and I wanted it to be 92102A92 on the output. The number of leading zeroes can very and as you can see, there are alphas in my varchar field. I tried to use trim(DSLink123.MY_FIELD,"0...

The problem is that the file never finishes being created because it fills up the disk too quickly. I guess I could try reducing the input to the point where the output would be able to get created and finish (75,000 rows would finish... the original input was 1.2 million). I'll try that and see wha...

I have 150 columns that are all VarChar(500)'s but the partitions in the scratch space are still very large when I set every one of those columns to null using the SetNull() function. ~75,000 rows produces a dataset with 2 partitions each of sizes around 6.0 GB for a total of around 12.0 GB. The onl...

Any reason why you are not using the surrogate key stage, which generates key much more efficiently, or a parallel transformer counter field as described in the FAQ forum. Both methods can be passed a start value and will concurrently increment across partitions. I have considered the surrogate key...

Hi, I am primary keying records with the KeyMgtGetNextValueConcurrent() routine from within a Server Container that I am using inside of a Parallel job. It has worked in the past and I do not know what variable has caused it not work now. Recently I have been getting the following error message in t...

Hi Aaron, Try LIST filename WITH columnname = 'value' :lol: Thanks, Chester That works but I'm not sure how well it will work with 102 million rows. I tried is on a smaller has file of 2 million and it take about 5 min to return. Thanks Chester's way seems like the only way, and will perform at O(n...

Why not 'View Data' and then use the Find option there? Craig there are over 102 million rows in my hash file this option is not feasible. Thanks Yes, you'd have to skip every time your search failed, viewing 9999 rows at a time. Sounds like too much fun. If your record was at the very bottom, you ...

What is the difference between the Filter stage and the Switch stage? Functionally, they seem to do the same thing, unless I am missing something. I know the Switch stage uses a C style case statement, so in terms of performance, is one better than the other? Are there any other considerations to ta...