Convert String characters to a collection

[HarjitSamra]

Hi,

I'm trying to take a string and add each of it's characters to a collection.  

So for string

TEST STRING

I would populate a collection with

Record 1 - T

Record 2 - E

Record 3 - S

etc.

Any ideas?

[iAm_ManCat · Accepted solution]

Hi!

Have you considered using the Split() function, this will split the text into single characters if you use the separator of "" rather than an actual text value.

ClearCollect(ThisCollection, Split(TextToSeparate, "") );

Could you give that a try and let me know if you run into any issues?

Thanks,

Sancho

[HarjitSamra]

Thanks @iAm_ManCat  - works perfectly.  I never thought of using Split with an empty string - though I did see in the Microsoft help Docs for Split.. 🤔😁

[iAm_ManCat]

Glad I could help, I've had to use it again recently so it was fresh in my mind 😺

Hope you have a great day!