extract values from a string column

[tma_new2kdb]

select date,account from table2010.01.01,"my_account"2010.01.01,"ur_account"how do i make this display2010.01.01,"my"2010.01.01,“ur”

[f11]

Hello,

select date,first each"_"vs’account from table

Regards,

Fintan.