cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Invalid Character in Parent Nodes from BW?

Former Member
0 Kudos
171

Hi,

When loading Master Data for GL_Account we are getting Parent Nodes with Invalid Char like "/".

Ex: INT 1044000/23.

I want only 1044000. I have removed "INT ".

Not able to remove /.

I tried conversion file with:


Internal     External

  *              js:%external%.replace("/","")

Internal     External

  *              js:%external%.toString.replace("/","")

Also tried replacing Internal with /, */*, /*.

Nothing helped me.

Please Suggest a solution.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

You can test below code in Online Javascript Editor

<!DOCTYPE html>

<html>

<body>

<script>

var external = "1044000/23";

var str;

str =external.split("/").join("")

alert(str)

</script>

</body>

</html>

former_member186338
Active Contributor
0 Kudos

split/join is a possible but not very effective solution. Replace with regular expression syntax is a better way. Look on my reply in the second duplicated discussion:

Vadim

Former Member
0 Kudos

Hi ,

Try this one.

js:%external%.split("/").join("").



more detail refer below link.


Former Member
0 Kudos

Hi,

Also refer below thread

hope this will help you.

Former Member
0 Kudos

Hi,

Try js:%external%.toString().split("/").join("")

Andy