join columns

[JB]

Your sample has opened the door to arrays for me.
I love arrays now that I know how to use them.

thanks a lot!

John Balgenorth


On Aug 28, 2014, at 5:51 PM, Phil Davis <revdev at pdslabs.net> wrote:

> 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
> 
> 
> _______________________________________________
> 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
>