Skip to main content
Christina_Jarosz
Christina_Jarosz
Level 9
January 26, 2022
Solved

Is there a 'TextToColumns' method in WF?

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
RandyRoberts
RandyRobertsAccepted solution
Community Advisor
January 26, 2022

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 in thread

1 reply

RandyRoberts
Community Advisor
RandyRobertsCommunity AdvisorAccepted solution
Community Advisor
January 26, 2022

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

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...