AnsweredAssumed Answered

substring a column

Question asked by DanielMarcelino on Mar 26, 2011
Latest reply on Mar 28, 2011 by philmodjunk

Title

substring a column

Post

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

Outcomes