How to Filter excess 0's in an Alphanumeric ID

[Former Member]

Hi, experts

There is an account ID that leads with letters then goes to numbers. such as YDEP00001148595.

How can I remove the Zeros before the 5. I am trying to do this through a conversion file but the javascript js:parseInt(%external%) and it does not work. I am working on BPC 10.1 NW

[former_member186338 · Accepted solution]

Use substring!

js:parseInt(%external%.toString().substring(5)).toString()

Vadim

[Former Member · Accepted solution]

What Should I do if the length Varies.

[Former Member · Accepted solution]

Hi,

if you have ABAP resource you can use end routine to remove the 0s.

Or you can use conversion file with something like

????000000*

????00000*

????0000*

????000*

then remove 0 for each line, just a work around.

Andy

[Shrikant_Jadhav]

Hi

If number of zero's and length of ID is fixed then use

ACCOUNT=0GL_ACCOUNT(1:4)+0GL_ACCOUNT(9:15)

Shrikant

[Former Member]

The ID length is not fixed. It varies.

[former_member186338]

The character part of the ID has to be fixed length for this formula - "YDEP"

"What Should I do if the length Varies." - you have to explain the requirements from the very beginning!

Vadim

[Former Member]

Hi,

Is it a compounded info object?

try split the ID first, then parseInt the number part, then join again.

Andy