Master Data Load: Skip members with special characters

[simon_kussmann]

Hi all,

I am currently trying to load master data into BPC.

The member IDs could have the following structures:

?IS?

.? 22W

???XXCW

***XYZ

$$$XYZ

I want to Skip all of these members, how can I find these special characters in my string?

Thanks in advance!

[gajendra_moond · Accepted solution]

Hi Simon

Say you want to skip members beginning with given special characters, you can achieve that by defining under SKIPIF option of the transformation file:

This will skip the members beginning with these characters.

Secondly, I assume that you are trying to load only alphanumeric values as your member IDs. In case you do not wish to skip, you can remove these special characters and keep the alpha-numeric string only by using the conversion as below:

[simon_kussmann · Accepted solution]

Thanks, SKIPIF works with members beginning with special characters. But as Vadim asks, I also want to skip special characters in the member names.

[former_member753668 · Accepted solution]

Dear Gajendra,

is it possible for use to include the special characters ? in order master data

Thank You.

[former_member186338 · Accepted solution]

andrew1995

It's a bad idea to post comment in 6 year old question. Please ask a new question and I will help you.

[former_member186338]

Hi Simon,

Do you want to skip members containing some list of characters?

Or do you want to skip members with some specific format?

Or do you want to skip special characters in the member names?

Vadim

[former_member186338]

If you want to skip members containing some list of characters (and this list is containing special characters like "*" and "?") then you have to use routine badi. Javascript in conversion file is only able to change the member id, but not to skip it. You may try to rename all "bad" members to some dummy id...

Vadim

[simon_kussmann]

If I use SKIPIF = * BPC skips members with the character * in the description as well. But this should only happen with the ID of the member. Any Ideas?

[former_member186338]

If you look on help for SKIPIF you will see:

"This option causes the transformation to skip a line in the data file if it begins with the specified strings."

It's about line beginning!

[anil_agrawal]

Hi,

You need to define only your way. You suppose to careful about their sequences, the order  of your statement suppose to be specific to generic.

Like first statement ?IS? and in next  statement suppose to be *IS*

Thanks,

Anil

[Former Member]

Hi Simon,

You can achieve this in your Conversion file.

In EXTERNAL you type "*" and in INTERNAL you type js:%external%.split('?').join('').split('$').join('')..........

whichever character you want to skip, just mention it in split('character to skip').join('')

Also you can use replace function in INTERNAL for e.g. js:%external%.toString().replace(/\s+/g,"")

Thanks.