user10780 Member

• Activity
• Discussions2
• Comments3

Comments

• hi ashleigh, your solution was rather vague, but I worked it out: ^.*[a-zA-Z].*$

  in Magic ETL doing regex_like: making a text column numeric and all non numeric values set to -1 Comment by user10780 August 2019
• thanks for the reply! Version 5.0 Yes, it is an ODBC connection as I can connect using ODBC for IBM DataStage, and I can also connect using SQL Server Management studio on my laptop

  in Workbench connecting to MS SQL Server "Value cannot be null. Parameter name: input" Comment by user10780 July 2019