I need to extract the second letter in a column of a table for a complex sql, the substr function and substring function is not work, what can i do for it?
I need to extract the second letter in a column of a table for a complex sql, the substr function and substring function is not work, what can i do for it?
Dot-syntax and methods/commands using square brackets don't work in queries. You can setup user commands though that return the wanted value.
In this case you can also use the deprecated command "stringpart()".
- Table.query("SELECT stringpart([Col], 1, 1) FROM GlobalTable1").cloneTo(Table("GlobalTable2"));
11 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2024 Autodesk Inc. All rights reserved