INDEXOFARRAY(SPLIT("12345_111","_"),1)->12345

INDEXOFARRAY(SPLIT("12345_111","_"),2)->111

oracle：

SELECT    SUBSTR('your_string', 1, INSTR('your_string', '_') - 1) AS field1,    SUBSTR('your_string', INSTR('your_string', '_') + 1) AS field2 FROM your_table;

mysql：

SELECT    SUBSTRING_INDEX('your_string', '_', 1) AS field1,    SUBSTRING_INDEX('your_string', '_', -1) AS field2 FROM your_table;

sql server：

SELECT    SUBSTRING_INDEX('your_string', '_', 1) AS field1,    SUBSTRING_INDEX('your_string', '_', -1) AS field2 FROM your_table;

单元格写公式split("12345_111","_")，然后设置向下扩展就可以得到两行数据了，分别是12345和111