join columns

[Phil Davis]

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