How To Remove Nested Spinning With Excel

by 4 replies
5
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
#programming #excel #nested #remove #spinning
  • 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.
    • [1] reply
    • we also have the concat operation so that can be used handy with macro
  • hm, seems to be more difficult than I thought, thanks so far.

    maybe there are others who can solve it easily?
  • oops, whats that?
Join the discussion

Next Topics on Trending Feed