Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kkarlste
Creator
Creator

skript number

Hi

Take all the numbers before the dash for example A51273-2
and then take all numbers after that this must show this 51273

 

Kalle

 

Labels (1)
1 Reply
sbaro_bd
Creator II
Creator II

Hi @kkarlste ,

Right(Subfield(Dimension,'-',1),5)

OR

Right(Subfield(Dimension,'-',1),Len(Subfield(Dimension,'-',1))-1)

Regards