how can I do to have two in two columns. ( 1 2 3 4 5 6 7 columns)



  • Hi all, I have a big text file and the data in it are in 7 columns, but how can I do to have two in two columns.
    ( 1 2 3 4 5 6 7 columns)
    “name”:"1 80.97.120.40 180 ms [n/a] 21 “type”:“A” @post
    “asn”:6876 90.97.117.177 134 ms [n/a] 20 “type”:“B” @post
    “asn”:23650 70.97.120.10 75 ms [n/a] 21 “type”:“A” @contact
    “ttl”:60 70.97.122.105 87 ms geodnsd-global-sonicwall-com 20 “type”:“C” @contact
    “asn”:15399 70.97.122.106 89 ms geodnsd-global.sonicwall-com 19 “type”:“A” @contact
    “ttl”:7896 70.97.122.107 95 ms www-psmythe-net 21 “type”:“B” @post
    “asn”:456 70.97.122.104 98 ms wasabi-prostructure-com 22 “type”:“C” @contact
    “name”:"376 70.97.122.108 89 ms server_ip 21 “type”:“B” @contact
    “asn”:15343 70.97.122.109 87 ms xcder-com 21 “type”:“A” @post

    I need results like this example
    1 2
    1 3
    1 4
    1 5
    1 6
    1 7

    2 1
    2 3
    2 4
    2 5
    2 6
    2 7

    and so on with the others.



  • @vincitysportia-hero :

    Remarkably similar (in fact, virtually identical) to this posting from a month ago. Is it possible you are coming back here under a different user id? If so, did you not get the answer you wanted earlier??



  • @Scott-Sumner

    maybe it’s a BIG company that hired a few trainees, gave them all a copy of notepad++ and the same task …

    … and within the next weeks, we’ll see the same question again and again, from all of them, because none of them was successful … lol ;-)



  • @Meta-Chuh

    Well, maybe… Let’s see if at least one of the “trainees” can put forth the question in such a way as to get a satisfactory answer.


Log in to reply