Does table sql queries have a function like substr?

Question

question

yexioamu asked Dec 11, '24 yexioamu commented Dec 11, '24

Does table sql queries have a function like substr?

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?

Software Version:

FlexSim 21.2.4

sql queries

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2024-12-11T08:25:11Z

Felix Möhlmann answered Dec 11, '24 yexioamu commented Dec 11, '24

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"));

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

yexioamu commented · Dec 11 at 08:46 AM

thank you! it works, but it has a point to note, the second parameters, the num start, countsing starts from zero.

0 ·

question