Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
thamyribas
Partner - Contributor II
Partner - Contributor II

Exclusão de caracteres

Bom Dia galera,

  Estou precisando deletar todos os caracteres depois do ( - ), como faço?

segue os dados que preciso tratar:

 

10204500 - Portuario Folha                     
10204500 - Portuario Folha                     
10204500 - Portuario Folha                     

10902050 - Despesas Extraordinarias

Obrigadinha!

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Trim(SubField(FieldName, '-', 1)) as NewField

View solution in original post

3 Replies
sunny_talwar

May be this

Trim(SubField(FieldName, '-', 1)) as NewField

thamyribas
Partner - Contributor II
Partner - Contributor II
Author

Thanks, I'll do a test.

thamyribas
Partner - Contributor II
Partner - Contributor II
Author

Perfect! Very Thanks!