This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a long string of values that is merged together. I need to insert a delimiter after every 6th character; there is no other consistency in the values (i.e. case, what the character is). I am trying to use the RegEx tool but can't figure out how to specify to insert the delimeter in this position.
String looks like this - ab111cde222fgh333i
Needs to come out like this: ab111c;de222f;gh333i so that I can then separate them into individual columns (ab111c would go in one column, de222f would go in a second, etc.).
That helped - thank you! I wasn't able to use the unique values + cross tab since there are many other columns I'm working with outside of this one, but using Tokenize in the RegEx tool worked and I was able to output into columns all in one step as you suggested. Thanks!
Thanks for the help. I liked using the ... in Tokenize as it's easier for me to remember going forward. I'll need to play with the summarizing since there are many other columns in my actual file outside of this one, but for now my immediate issue was solved! Thanks!