Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!
SOLVED

Is there a 'TextToColumns' method in WF?

Avatar

Level 9

I'd like to split out a project name:

000000-ABC-Project Name

So that I'm only getting the Project Name portion?

Any ideas?

1 Accepted Solution

Avatar

Correct answer by
Level 10

I got a tip from @Skye Hansen‚ that might help you. Skye suggested doing a count using LEN( and then subtract the number of characters in the job number, providing it's consistent, and display the rest. Something like RIGHT(Name,(LEN(Name)-11) . That's if there are 11 characters in the job number.

If you had a consistent character in the job number, you could use another method I got from @Teale McCleaf‚.

That is to use the special character as a delimiter like in an email address. LEFT({emailAddr},SEARCH("@",{emailAddr})). this pulls the LDAP name of the user separate from the domain name.

Hope this helps.

credit given where credit is due

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

I got a tip from @Skye Hansen‚ that might help you. Skye suggested doing a count using LEN( and then subtract the number of characters in the job number, providing it's consistent, and display the rest. Something like RIGHT(Name,(LEN(Name)-11) . That's if there are 11 characters in the job number.

If you had a consistent character in the job number, you could use another method I got from @Teale McCleaf‚.

That is to use the special character as a delimiter like in an email address. LEFT({emailAddr},SEARCH("@",{emailAddr})). this pulls the LDAP name of the user separate from the domain name.

Hope this helps.

credit given where credit is due