How to avoid data trimming while formatting file in unix











up vote
0
down vote

favorite












I have a file in below format



A           |b -c          |   c      |  d  -c | | |


And I need to format the above file like below



A|b -c|c|d  -c|||


Please note, I don't want to remove the space from data.I just want to remove the extra space before the data terminator i.e | (pipe).






text-formatting







share|improve this question
























  • Is it fair to say that you now want to remove space from after the pipe as well?
    – Jeff Schaller
    Nov 16 at 20:38










  • If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
    – Jeff Schaller
    Nov 18 at 13:25















up vote
0
down vote

favorite












I have a file in below format



A           |b -c          |   c      |  d  -c | | |


And I need to format the above file like below



A|b -c|c|d  -c|||


Please note, I don't want to remove the space from data.I just want to remove the extra space before the data terminator i.e | (pipe).






text-formatting







share|improve this question
























  • Is it fair to say that you now want to remove space from after the pipe as well?
    – Jeff Schaller
    Nov 16 at 20:38










  • If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
    – Jeff Schaller
    Nov 18 at 13:25













up vote
0
down vote

favorite









up vote
0
down vote

favorite











I have a file in below format



A           |b -c          |   c      |  d  -c | | |


And I need to format the above file like below



A|b -c|c|d  -c|||


Please note, I don't want to remove the space from data.I just want to remove the extra space before the data terminator i.e | (pipe).






text-formatting







share|improve this question















I have a file in below format



A           |b -c          |   c      |  d  -c | | |


And I need to format the above file like below



A|b -c|c|d  -c|||


Please note, I don't want to remove the space from data.I just want to remove the extra space before the data terminator i.e | (pipe).






text-formatting




text-formatting






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 16 at 20:22









steeldriver

33.6k34982




33.6k34982










asked Nov 16 at 17:56









user313150

113




113












  • Is it fair to say that you now want to remove space from after the pipe as well?
    – Jeff Schaller
    Nov 16 at 20:38










  • If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
    – Jeff Schaller
    Nov 18 at 13:25


















  • Is it fair to say that you now want to remove space from after the pipe as well?
    – Jeff Schaller
    Nov 16 at 20:38










  • If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
    – Jeff Schaller
    Nov 18 at 13:25
















Is it fair to say that you now want to remove space from after the pipe as well?
– Jeff Schaller
Nov 16 at 20:38




Is it fair to say that you now want to remove space from after the pipe as well?
– Jeff Schaller
Nov 16 at 20:38












If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
– Jeff Schaller
Nov 18 at 13:25




If any of the answers solved your problem, please accept it by clicking the checkmark next to it. Thank you!
– Jeff Schaller
Nov 18 at 13:25










2 Answers
2






active

oldest

votes

















up vote
2
down vote













One option would be to use sed to say "replace one or more spaces followed by a pipe with a pipe" -- and do that for every occurrence of those spaces & pipes:



sed  's/  *|/|/g' < input > output


To also remove spaces after the pipe:



sed  's/  *|/|/g; s/|  */|/g' < input > output





share|improve this answer























  • Thanks a lot ..It worked.
    – user313150
    Nov 16 at 18:08












  • what If I want to remove extra spaces before pipe | too..
    – user313150
    Nov 16 at 18:10












  • doesn't the above remove extra spaces before the pipe?
    – Jeff Schaller
    Nov 16 at 18:25










  • No..it didn't remove
    – user313150
    Nov 16 at 18:46










  • Do you have two spaces between the first slash and the asterisk?
    – Jeff Schaller
    Nov 16 at 18:49


















up vote
0
down vote













You could use Awk, setting the input field separator to a pipe surrounded by any amount of whitespace and the output field separator to just a pipe:



awk 'BEGIN {FS="[ t]*\|[ t]*"; OFS="|"} {$1=$1} 1' file





share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "106"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f482208%2fhow-to-avoid-data-trimming-while-formatting-file-in-unix%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    2
    down vote













    One option would be to use sed to say "replace one or more spaces followed by a pipe with a pipe" -- and do that for every occurrence of those spaces & pipes:



    sed  's/  *|/|/g' < input > output


    To also remove spaces after the pipe:



    sed  's/  *|/|/g; s/|  */|/g' < input > output





    share|improve this answer























    • Thanks a lot ..It worked.
      – user313150
      Nov 16 at 18:08












    • what If I want to remove extra spaces before pipe | too..
      – user313150
      Nov 16 at 18:10












    • doesn't the above remove extra spaces before the pipe?
      – Jeff Schaller
      Nov 16 at 18:25










    • No..it didn't remove
      – user313150
      Nov 16 at 18:46










    • Do you have two spaces between the first slash and the asterisk?
      – Jeff Schaller
      Nov 16 at 18:49















    up vote
    2
    down vote













    One option would be to use sed to say "replace one or more spaces followed by a pipe with a pipe" -- and do that for every occurrence of those spaces & pipes:



    sed  's/  *|/|/g' < input > output


    To also remove spaces after the pipe:



    sed  's/  *|/|/g; s/|  */|/g' < input > output





    share|improve this answer























    • Thanks a lot ..It worked.
      – user313150
      Nov 16 at 18:08












    • what If I want to remove extra spaces before pipe | too..
      – user313150
      Nov 16 at 18:10












    • doesn't the above remove extra spaces before the pipe?
      – Jeff Schaller
      Nov 16 at 18:25










    • No..it didn't remove
      – user313150
      Nov 16 at 18:46










    • Do you have two spaces between the first slash and the asterisk?
      – Jeff Schaller
      Nov 16 at 18:49













    up vote
    2
    down vote










    up vote
    2
    down vote









    One option would be to use sed to say "replace one or more spaces followed by a pipe with a pipe" -- and do that for every occurrence of those spaces & pipes:



    sed  's/  *|/|/g' < input > output


    To also remove spaces after the pipe:



    sed  's/  *|/|/g; s/|  */|/g' < input > output





    share|improve this answer














    One option would be to use sed to say "replace one or more spaces followed by a pipe with a pipe" -- and do that for every occurrence of those spaces & pipes:



    sed  's/  *|/|/g' < input > output


    To also remove spaces after the pipe:



    sed  's/  *|/|/g; s/|  */|/g' < input > output






    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited Nov 16 at 20:39

























    answered Nov 16 at 18:00









    Jeff Schaller

    36.3k952119




    36.3k952119












    • Thanks a lot ..It worked.
      – user313150
      Nov 16 at 18:08












    • what If I want to remove extra spaces before pipe | too..
      – user313150
      Nov 16 at 18:10












    • doesn't the above remove extra spaces before the pipe?
      – Jeff Schaller
      Nov 16 at 18:25










    • No..it didn't remove
      – user313150
      Nov 16 at 18:46










    • Do you have two spaces between the first slash and the asterisk?
      – Jeff Schaller
      Nov 16 at 18:49


















    • Thanks a lot ..It worked.
      – user313150
      Nov 16 at 18:08












    • what If I want to remove extra spaces before pipe | too..
      – user313150
      Nov 16 at 18:10












    • doesn't the above remove extra spaces before the pipe?
      – Jeff Schaller
      Nov 16 at 18:25










    • No..it didn't remove
      – user313150
      Nov 16 at 18:46










    • Do you have two spaces between the first slash and the asterisk?
      – Jeff Schaller
      Nov 16 at 18:49
















    Thanks a lot ..It worked.
    – user313150
    Nov 16 at 18:08






    Thanks a lot ..It worked.
    – user313150
    Nov 16 at 18:08














    what If I want to remove extra spaces before pipe | too..
    – user313150
    Nov 16 at 18:10






    what If I want to remove extra spaces before pipe | too..
    – user313150
    Nov 16 at 18:10














    doesn't the above remove extra spaces before the pipe?
    – Jeff Schaller
    Nov 16 at 18:25




    doesn't the above remove extra spaces before the pipe?
    – Jeff Schaller
    Nov 16 at 18:25












    No..it didn't remove
    – user313150
    Nov 16 at 18:46




    No..it didn't remove
    – user313150
    Nov 16 at 18:46












    Do you have two spaces between the first slash and the asterisk?
    – Jeff Schaller
    Nov 16 at 18:49




    Do you have two spaces between the first slash and the asterisk?
    – Jeff Schaller
    Nov 16 at 18:49












    up vote
    0
    down vote













    You could use Awk, setting the input field separator to a pipe surrounded by any amount of whitespace and the output field separator to just a pipe:



    awk 'BEGIN {FS="[ t]*\|[ t]*"; OFS="|"} {$1=$1} 1' file





    share|improve this answer

























      up vote
      0
      down vote













      You could use Awk, setting the input field separator to a pipe surrounded by any amount of whitespace and the output field separator to just a pipe:



      awk 'BEGIN {FS="[ t]*\|[ t]*"; OFS="|"} {$1=$1} 1' file





      share|improve this answer























        up vote
        0
        down vote










        up vote
        0
        down vote









        You could use Awk, setting the input field separator to a pipe surrounded by any amount of whitespace and the output field separator to just a pipe:



        awk 'BEGIN {FS="[ t]*\|[ t]*"; OFS="|"} {$1=$1} 1' file





        share|improve this answer












        You could use Awk, setting the input field separator to a pipe surrounded by any amount of whitespace and the output field separator to just a pipe:



        awk 'BEGIN {FS="[ t]*\|[ t]*"; OFS="|"} {$1=$1} 1' file






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 16 at 20:23









        steeldriver

        33.6k34982




        33.6k34982






























             

            draft saved


            draft discarded



















































             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f482208%2fhow-to-avoid-data-trimming-while-formatting-file-in-unix%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            List directoties down one level, excluding some named directories and files

            Image
            1 I want to send a list of all folders including one level down to a txt file. Excluding some named folders and no files. Imagine a folder structure like this. CAPS are folders. FOLDER 1 .hidden TEMP somefile ========= ========= FOLDER 2 .hidden TEMP DATA1 DATA2 somefile ======== ======== FOLDER 3 .hidden TEMP DATA1 somefile I would like to run "insert magic command here" and end up with an output that looks like below FOLDER 1 FOLDER 2 DATA1 DATA2 FOLDER 3 DATA1 bash shell-script share | improve this question edited Dec 16 at 4:15 Rui F Ribeiro ...
            Read more

            list processes belonging to a network namespace

            Image
            5 1 I am on Ubuntu 12.04, and the ip utility does not have ip netns identify <pid> option, I tried installing new iproute , but still, the option identify doesn't seem to be working!. If I were to write a script (or code) to list all processes in a network-namespace, or given a PID, show which network-namespace it belongs to, how should I proceed ? (I need info on a handful of processes, to check if they are in the right netns ) linux process network-namespaces share | improve this question edited Jun 30 '15 at 22:00 Gilles 529k 128 1060 1585 ...
            Read more

            list systemd RuntimeDirectory mounts

            Image
            3 I have a systemd service with this declaration: RuntimeDirectory=plex RuntimeDirectoryMode=750 which creates the in memory directory /run/plex . How would I list the capabilities of this mount point as I would do with mount -l ? systemd systemd-mount share | improve this question edited Jan 9 at 17:57 filbranden 7,400 2 8 37 asked Jan 9 at 17:40 adrhc adrhc 247 1 11 ...
            Read more