Greg
- Total activity 11
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 0
- Subscriptions 2
Comments
Recent activity by Greg-
Never Mind!I found the field that was set to string in the import job and changed it to Boolean and that fixed the problem
-
Hi Alan I just learned today that we are upgrading to 7.4 in a few weeks.In the mean time your workaround using the formula bar to make the replacement and then referring to that sheet in the SQL i...
-
Hi Alan It is requesting I run at the bottom but when I do, I get an error.This error log includes the line Unsupported number of arguments: Expected 4 but was 3 Tried on other columns but the issu...
-
Thanks AlanStill not working for me though... This works as expectedSELECT Entity_LegalName FROM GLEIF ( returns 5K rows) Change it to thisSELECT REPLACE(Entity_LegalName, 'LTD', 'LTD.') FROM GLEIF...
-
Hi Konsta I am using version 7.2.3I can replicate what you provided in the formula bar, and it works.The sample you provided is exactly what I am after However, what I am trying to do is incorporat...
-
And also got an error message about the ; it seems it wants ,
-
Thanks for your quick reply AlanCan't get it working though...I copied your example exactly REPLACEALL(#Sheet!Column; 'A'; 'B') and the first error I got was:Lexical error at line 5, column 12. Enc...