Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been trying to avoid the special character like 312328-342344 ("-") and have output as 312328342344 or even 312328 342344 but it is not happening. Can you please help me on this. I did try the following;
row2.ColumnName.replaceAll("[-]", "") and more but it doesn't work, I keep getting error. This has a data type string by the way. Can somebody help on this?
Hi, I tried your logic in tMap but it doesn't seem it is working.
I am trying to avoid "-" from AdminPartyId and only want those values given for AdminSystemValue. I can get those values on AdminSystemValue with the logic I have but never for AdminPartyId.
You need to give a bit more information. What exactly did you try (ie show the code....copy and paste it here)? What was the error message?
Hi, Please forget about the other filters. Now I only have
row2.AdminPartyId.replaceAll("[-]","")
Could you please help me getting rid of "-" character from AdminPartyId?
That should work. The only thing you are possibly missing is a check for null. Are you getting any errors or is it just not removing the "-"? Can you show how this is used in your tMap? A screenshot of your complete tMap may help
Hi, I am getting error with just the filter (
row2.AdminPartyId.replaceAll("[-]","") )
and below is the error message;
Error Line: 3791
Detail Message: Type mismatch: cannot convert from String to boolean
Can you please take a screenshot of your tMap? You are leaving out important information. The error...
Type mismatch: cannot convert from String to boolean
....suggests that you are trying to set a boolean value with a String. This suggests to me that either you are setting an incorrect column type OR you are using that logic in a filter. I cannot tell when you post your code. It MUST be a screenshot.
Hi,
Are you using replace function in filter ? if yes then what are you trying to get out put?
You can use variable ports in tMap to clean data first then use that variable port in filter.
Regards,
I was trying with replaceAll function to avoid "-". So you think I need to do on Variable ports? Could you please suggest me exactly what I need to mention as expression?
try this
Regards,