Using Boomi to cut variable length string at first white space

111 Views Asked by At

I have a list of consignors that have a variable ID number at the beginning of their name followed by a space and would like to remove the number and first space.

I do not see a string function that will do it. The cut function doesn't work because the line has multiple spaces. For example, if I have "1234 My house" I want it to be "My house" The second space is causing the issue.

1

There are 1 best solutions below

1
On

Another way to look at is replace a leading number plus white space with nothing.

str = str.replace(/^\d+\s*/, '');