phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

XML import to Excel and remove characters

  • Posted:
  • Proposals: 3
  • Remote
  • #3195208
  • Awarded
Mahmoud A.Muhammad Barkat H.Anuradha .. have already sent a proposal.
  • 1

Description

Experience Level: Entry
I have an XML workbook that needs to be copied into excel. Once copied to Excel if needs to search for a specific string like

The data can exist like this
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="ABC2-12346-ABC_6"
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="AB123-20MF"
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="BC6789_7"

The code needs to make the data like this
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="ABC2-12346-ABC"
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="AB123"
<Testing data = "1B67-Y675G-A" ProductName="Dummy" id="Bundle" partnumber="BC6789"

Only where is stays partnumber

File will be provided on request only

Data to be converted back into an XML file

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

    There are no clarification messages.