回應： Breaking a string into parts

[voiceburg]

I have a case like this

aaaaa,bbbbb,ccccc,ddddd,

The a, b, c, and d values are not the same on each read, different lengths

I need to remove the 4 commas and split the 4 segments out seperatly to use as variables in an equation.

How can this be accomplished?

Thank you in advance.

[crossrulz]

Use Spreadsheet String to Array.  Make the type a 1D array of whatever you data type you want (string, integer, floating point).  Set the delimiter to be a comma.  For the format, it depends on the data type you want.  For a string use %s, for an integer use %d, for a float use %f.

[JÞB]

try that baby

[billko]

That baby is a little too young for me...  😉

[billko]

Lots going on inside the 2012 version.  I guess it would save time versus strining all that stuff up...  🙂

[apok]

use scan from string with regex

[William1225]

Hi, there is another way to accomplish by using Spreadsheet String to Array.

[apok]

---

@William1225 wrote:

Hi, there is another way to accomplish by using Spreadsheet String to Array.

---

this had already been mentioned...   

[William1225]

XD...I didn't notice it, sorry to my carelessness....