join columns

[Phil Davis]

Arrays are great for many uses! I'm glad you got it to work. The BYU 
lessons are a good place to learn a lot.

Phil


On 8/28/14, 3:47 PM, JB wrote:
> Hi Phil,
>
> Thank you so many times!!!
>
> It does work.  I was thinking i needed to add more to it
> and never tried it like it was.
>
> This is my first time with arrays.  So I was looking around
> for infö and in the process came up with a good lesson on
> arrays.
>
> http://revolution.byu.edu/arrays/introToArrays.php
>
> Thanks again!
>
> John Balgenorth
>
> On Aug 28, 2014, at 3:43 PM, Phil Davis <revdev at pdslabs.net> wrote:
>
>> Hi John,
>>
>> It should work if you just say "combine pData by column" and nothing more. At least it does here - just tested it. It restructures the pData array back into its original list format, but with items moved to their new positions.
>>
>> Phil
>>
>>
>> On 8/28/14, 2:27 PM, JB wrote:
>>> Hi Phil,
>>>
>>> I am having trouble with the proper way
>>> to write the combine pData by column.
>>>
>>> I can split the columns and reverse them
>>> like you show but how do you write the
>>> code to combine them?  It looks to me
>>> from the dictionary the column needs
>>> to be a number but what line do I need
>>> to put them on?
>>>
>>> John Balgenorth
>>>
>>>
>>> On Aug 28, 2014, at 12:10 PM, Phil Davis <revdev at pdslabs.net> wrote:
>>>
>>>> If pData is a CR-delimited list where each line contains tab-delimited items, why not use 'split by column'?
>>>>
>>>> -- example: switch positions of columns 2 and 4
>>>>
>>>>    split pData by column
>>>>    put pData[4] into tTemp2
>>>>    put pData[2] into pData[4]
>>>>    put tTemp2 into pData[2]
>>>>
>>>>
>>>> -- then put it back together as a list:
>>>>
>>>>    combine pData by column
>>>>
>>>> That should do it.
>>>>
>>>> Phil Davis
>>>>
>>>>
>>>>
>>>> On 8/28/14, 11:54 AM, JB wrote:
>>>>> Richard Gaskin wrote a function to get a column
>>>>> from a list.
>>>>>
>>>>> function GetCol pData, pCol --Richard Gaskin
>>>>>      set the itemdel to tab
>>>>>      put empty into tReturnList
>>>>>      repeat for each line tLine in pData
>>>>>          put item pCol of tLine &cr after tReturnList
>>>>>      end repeat
>>>>>      delete last char of tReturnList -- trailing CR
>>>>>      return tReturnList
>>>>> end GetCol
>>>>>
>>>>> Does anyone know how to convert this so you can
>>>>> join the selected columns back together in any
>>>>> order you want?
>>>>>
>>>>> John Balgenorth
>>>>> _______________________________________________
>>>>> use-livecode mailing list
>>>>> use-livecode at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>>
>>>> -- 
>>>> Phil Davis
>>>>
>>>> _______________________________________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>>
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>>
>> -- 
>> Phil Davis
>>
>>
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>

-- 
Phil Davis