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 <[email protected]> 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 <[email protected]> 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 >>>> [email protected] >>>> 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 >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >>> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
