Need Help - Tried using Unix sed but no joy

Need Help - Tried using Unix sed but no joy

2
NewbieNewbie
2

    Jun 15, 2005#1

    I have a badly formatted xml document.

    on each line : I need to find the text between the start and end tags <col7>......</col7>
    and replace any occurrences of "<" or ">" with " < " and ">"

    any help would be greatly appreciated.

    Thanks

    Aboo
    6,683583
    Grand MasterGrand Master
    6,683583

      Jun 17, 2005#2

      This macro should do the job.

      InsertMode
      ColumnModeOff
      HexOff
      UnixReOff
      Loop
      Find "<col7>"
      IfNotFound
      ExitLoop
      EndIf
      EndSelect
      Key RIGHT ARROW
      Key LEFT ARROW
      StartSelect
      Find Select "</col7>"
      IfNotFound
      ExitLoop
      EndIf
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Find "<"
      Replace All SelectText "<"
      EndSelect
      Find Up "<col7>"
      Key RIGHT ARROW
      Key LEFT ARROW
      StartSelect
      Find Select "</col7>"
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Key LEFT ARROW
      Find ">"
      Replace All SelectText ">"
      EndSelect
      EndLoop
      Best regards from an UC/UE/UES for Windows user from Austria
      2
      NewbieNewbie
      2

        Jun 17, 2005#3

        THanks for that, It works a treat.

        regards

        Aboo