5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

How To Remove Nested Spinning With Excel

by seoed
4 replies
Hello,

I have an article which has nested spinning in it like:

{ bla blah {blah|blah} blah | blah blah {blah| blah} blah }

My aim is to remove the nested spinning in a way that only one version before or after the red pipe line can be taken, like:
bla blah {blah|blah} blah

so the outer { and the | has been removed. how can I achieve that with the help of openoffice (dont have excel)?

thanks and regards
#excel #nested #remove #spinning
  • Profile picture of the author tryinhere
    you will need to write a small macro to go in and edit that if the text is all different, such as find { then replace with blank, but with it nested like that, it will probably take a bit extra programming as that is quite a tricky little puppy to work around and may take some time to solve.

    not sure if you can do that in open office or if a find and replace will work ? but being a variable it may not, but if you were to try and code that in excel i would probably look for a generic find using a wild card, then copy that and get the length then create a new word with a divisor of 2 (-1 for the center pipe) and then use that as a replace for the wild card section found.

    if you were working in excel i could have a go at coding but sorry i do not work in OO

    i-freelancer.org < you may be able to get some help from here, but yes a tricky but simple one to code up, wish you the best with it.
    Signature
    | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
    {{ DiscussionBoard.errors[3768842].message }}
    • Profile picture of the author saimaspider
      we also have the concat operation so that can be used handy with macro
      {{ DiscussionBoard.errors[3768976].message }}
  • Profile picture of the author seoed
    hm, seems to be more difficult than I thought, thanks so far.

    maybe there are others who can solve it easily?
    Signature
    120% in 3 days
    {{ DiscussionBoard.errors[3768966].message }}
  • Profile picture of the author seoed
    concat operation
    oops, whats that?
    Signature
    120% in 3 days
    {{ DiscussionBoard.errors[3769088].message }}

Trending Topics