Answered

Looking to Add a Space in a string

(0) Share

Report

Posted on by MCubedMama

Hello,

I am looking for an expression to split up a value such as "ABC123" into "ABC 123", where there is a space added between the last character and the first numeric. Any suggestions out there? Thank you in Advance.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

trice602 16,021 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @MCubedMama ,

This should handle all scenarios. Please mark as a solution if this helps! Always glad to help! Tom

concat(slice(variables('Example1'), 0, 3), ' ', slice(variables('Example1'), 3))

where 'Example1' is my variable

Also, you can get these expressions built for you directly in the format data by Example tool.

Was this reply helpful? Yes No
MCubedMama 64 on at

Like (1)

Report
Copy link

Link copied!

Thank you! I wasn't aware of this tool.

Was this reply helpful? Yes No
trice602 16,021 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You will love it! I have found that while it is still valuable to know how these expressions are built, sometimes you just need the code to keep moving and it is a very helpful tool! Always glad to help! Tom

Was this reply helpful? Yes No