Remove leading characters from string ONLY if it is followed by a hyphen

heathers_ · ‎06-06-2018

Hello,

How would I script removing all characters from a string ONLY if it is followed by a hyphen? I do not want the characters removed if the hyphen is not at the end.

Example: hello- (should return null)

OR

hello (should return hello since there is not a hyphen)

Thanks!

ccajohnson · ‎06-06-2018

For this example, our source column is called User ID, which is the equivilant of u_user_id. Feel free to change the source field to whatever the source field is for your import. Taking the function Michael used, I have created the script that you can use for the user_name target field (I am guessing that this is the target field):

answer = (function transformEntry(source) {
    var chkString = source.u_user_id.toString();
    if (chkString.endsWith('-D')){
        return '';
    } else {
        return chkString;
    }
})(source);

View solution in original post

Brian Lancaster · ‎06-06-2018

I would just do an if statement like this and then overwrite my current string with an empty one.

if (filed.toString().indexOf('-') > -1){

set value of filed to null

}

heathers_ · ‎06-06-2018

I am mapping the user_name in a transform map. If the source value has a "-D" at the end, it indicates this value has been deleted and the target reference field needs to be null. Will this help accomplish this task? Currently it is blanking the value even if it shouldn't.

Brian Lancaster · ‎06-06-2018

Can you share you exact coding?

Michael Ritchie · ‎06-06-2018

The JavaScript endsWith function is better for this use case

if (source.user_name.endsWith("-D")) {
// do something
}

Informationally there is also a startsWith function too.