How to skip few digits from the field values?

[#1]

Hi Team,

How to skip few digits from the field values?

I just want to skip this first two zeros from the Sales Order field.

[rubenmarin]

Hi, in script you can use:

Num(Num#([Sales Order])) as [Sales Order]

[Anonymous · Accepted solution]

mid ( [Sales Order] , 3 )

[#4]

Hi,

Try

=Mid('0010146623',3)    => gives 10146623

The 2nd parameter of Mid() function specifies the Start Count !

Hope it helps !

[Anonymous]

Hi Murali,

Yes You can use Mid function:

In UI:

= Mid ( [Sales Order] , 3 )

In Script

Mid([Sales Order ID],3) as [SalesOrderID]

Regards

Neetha

[MarcoWedel]

Hi,

another solution could be:

works for text input

and

numerical input as well

hope this helps

regards

Marco