substring a column
Hello all, because I'm new in FM I'm losing my head to take off numbers and words from a string column.
For ex, if I have in one column both cases below, how can I split these strings into other columns?
13789 - BIVAR DE SOUZA DUDA - PB - Deputado Estadual
40444 - - PSB - - Deputado Estadual / 456 - CASSIO RODRIGUES DA CUNHA LIMA - PB - Senador