Split word

(0) Share

Report

Posted on by davepokpong

I want to cut word like 'CCA134009876' to '134009876'.

What should I do?

Thankyou.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @davepokpong

The formula would be -

split(outputs('Compose'),'1')[1]

This will only work if the number starts with digit '1'.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
SimonSmith84 112 on at

Like (1)

Report
Hi @davepokpong,

Could you be more specific about the criteria here?

For this exact solution, CFernandes' solution is perfect, but as he said, it'll only work if the first character is a "1". Just by looking at your question, I can see a few different logical methods that could be applied (which would require different methods).

Removing all text from the string, leaving just numbers
Removing the first 3 characters of the string
Remove everything before the first "1" (Cfernandes has answered this one)
If you can clarify the requirements, you'll get a much more suitable answer 🙂

Was this reply helpful? Yes No
davepokpong 10 on at

Like (0)

Report

Hi, @SimonSmith84

It's a second choice. I want to 'removing the first 3 characters of the string'.
What I should do?

Thankyou.

Was this reply helpful? Yes No
Verified answer

SimonSmith84 112 on at

Like (1)

Report

You can use the 'Compose' feature with an expression inside it, like this:
the expression would be written as follows:
substring(variables('davepokpong'),3,sub(length(variables('davepokpong')),3))

Obviously in your specific case, you'd replace the variable name with whatever your variable is called. If you'd like to understand the functions that are used a bit better, the below articles can help.

Substring: https://manueltgomes.com/reference/powerautomate-function-reference/substring-function/

Sub: https://manueltgomes.com/reference/powerautomate-function-reference/sub-function/

I hope this helps!

Was this reply helpful? Yes No
davepokpong 10 on at

Like (1)

Report

It works!

Thankyou @SimonSmith84

Was this reply helpful? Yes No