Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
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
Creator

Hi @kkarlste ,

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

OR

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

Regards