hello everyone i am probably having a mental block but can someone recommend the best way to split a string into specific columns? the string is nonspecific-it changes from 9 characters to 15
for example:
this is my data
column A
ABCDEFGHIJKL
ABCDEFGHI
this is the output i am wanting :
column A column B column C
ABC DEF GHIJKL
ABC DEF GHI
Solved! Go to Solution.
I would suggest regex parse mode.
(\w{3})(\w{3})(.+)
Here is how you can do it.
Workflow:
Hope this helps : )
@atcodedog05 yup! that worked! solved!
Happy to help : ) @utsarunner981
Cheers and have a nice day!