convert array to tab delimited data

[inbo712]

I am trying to build a function that will take any array (no matter how many dimensions it might have) and display it as tab delimited data. I found this on livecode lessons: (how-do-i-display-an-array-in-human-readable-form) and tried modifying it to this:

function displayArray pArray, pIndent
# create the variable that loops through the keys in the array

local tKey
if pArray is an array then
# print information to indicate that we are entering a new nested level of the array
get return

# create the indentation
put tab after pIndent
repeat for each key tKey in pArray
# call displayArrayData with a nested array
put format("%s%s%s\n", pIndent, tKey, displayArray (pArray[tKey], pIndent)) after it
end repeat
delete the last char of it
put it into tlist
else
put pArray into tlist
end if
return tlist
end displayArray

This gets me close but the array is displayed in kind of an outline form. What I want is tab delimited. Does anyone have any thoughts?

[mrcoollion]

Hello inbo,

Do not know if this is the goal but you can very easy show your complete array as a treeview by using the Tree View Widget.

This is very easy .
Place the Tree View widget in a card and give it a name (e.g. myarrayview )
Then use the below statement to fill the tree view widget with your array data.

Code: Select all

set the arraydata of widget myarrayview  to yourarrayname

More info on Tree View Widget
http://livecode.wikia.com/wiki/Tree_view_widget
https://livecode.com/docs/9-0-0/compone ... ew-widget/

Regards,

Paul

[sphere]

Code: Select all

set the itemdel to tab

now every piece of data separated by tab on a line will be an item

then create a repeat function to place every item of each line of your data to the field where you want it to be displayed

[Thierry]

Hi,

Is this what you want?

datas from:
http://lessons.livecode.com/m/4071/l/21 ... dable-form


If yes, then try this script:

Code: Select all

function flattenArray A , d1, d2, T,  X
   if T is empty then
      if d1 is empty then put cr into d1
      if d2 is empty then put tab into d2
   end if
   if A is not an array then return T  & X & A & d1
   repeat for each key K in A
      put flattenArray( A[K],  d1, d2, T,  X & K & d2 )  into T
   end repeat
end flattenArray

and to call this function:

Code: Select all

on mouseUp
   -- use implicit delimiters settings ( d1 and d2)
   put flattenArray( tCustomerDataArray) into fld 1
   -- or set primaryDelimiter (d1) and use default's secondaryDelimiter
   --     put flattenArray( myArray, return )
   -- or set both delimiters
   --     put flattenArray( myArray, return , " - ")
end mouseUp

HTH,

Thierry

[bogs]

Thierry, wonderful to see you post, it has been much too long!

[inbo712]

Thierry,

Thank you for the flattenArray function. That was exactly what I needed.

[Klaus]

Hi inbo712,

welcome to this wonderful forum!


Best

Klaus

Very personal note:
A little e.g. "Hello" would not have hurt for the first posting.

[Thierry]

Thank you for the flattenArray function. That was exactly what I needed.

Glad that it works for you!
And welcome to the LC world...

Thierry, wonderful to see you post, it has been much too long!

Nice to see again your legendary friendly and gentle attitude.
Much appreciated

Thierry

[[-hh]]

This is VERY useful for callbacks from JavaScript, using LC's javascriptHandlers.
And also (the excellent technique) for use in LC Builder.

Welcome back Thierry, and thanks for that!

[Thierry]

VERY useful for callbacks from JavaScript, using LC's javascriptHandlers.
And also (the excellent technique) for use in LC Builder.

Welcome back Thierry, and thanks for that!

Thanks Herman,

sunnY- 2019-01-14 à 14.28.16.png (188.6 KiB) Viewed 6607 times

If you are using it for this purpose, you might be interested with a more effective one,
hard coding the delimiters:

Code: Select all

function flattenArraySpeedy A, T, X
   if A is not an array then return T  & X & A & cr
   repeat for each key K in A
      put flattenArraySpeedy( A[K], T,  X & K & tab )  into T
   end repeat
end flattenArraySpeedy

and here is a function which does the reverse:

viewtopic.php?f=6&t=29798&p=158579&hili ... ne#p158579

Enjoy your day,

Thierry

[bogs]

Thierry, that is pure awesome, both sentiment and code