Hi, I have a STRING message and I need to converse in a 2d array, using the = as separator (variable = value). Below is what I have:
String originalVIconverted string
Go to Solution.
replace all tabulators by linefeeds.
Then call SpreadsheetStringToArray with "=" as separator, and change the array constant to a 2D array!
And just to show what GerdW was saying...
The two functions there are Search And Replace String and Spreadsheet String To Array.