How to add blank inbetween cell values

Question

Hi Team,

I have a content in the cell  like AABCABCHDAKIJHUHYGTRLKJHTBAGRTLKJHYLFGHTPQWERPTHFM this. Now what I want has a output is, I want to add " " a blank space into this cell at the series of five characters. So after every 5th character I want to add the blank space.

The output should like AABCA BCHDA KIJHU HYGTR LKJHT BAGRT LKJHY LFGHT PQWER PTHFM

Can anyone please help on this to solve.

atcodedog05 · Accepted Answer

Hi @Gsiva3

Here is how you can do it.

workflow:

1. Using record id i am creating row id. This will be the key reference just in case you have multiple rows.

2. Using Regex tool tokenize mode i splitting 5 letters to each row.

3. Using Summarize with record id (key) on groupby i am conacting the rows with separator " " space to get the desired output. Just for reference i am creating input field by concating the rows with no separator.

Hope this helps 🙂

Qiu · Accepted Answer

@Gsiva3 
We can trust RegEx. 😁

atcodedog05 · Accepted Answer

Manh posted nearly at the same time @Qiu with few seconds difference 😅 Close call

atcodedog05 · Accepted Answer

Hi @Gsiva3

REGEX_Replace([Input], "(\w{5})(\w{5})", "$1*$2")

Just replace " " with "*" in between $1 & $2.

Hope this helps 🙂