Batchdatei - HTML-Code aus CSV-Datei entfernen

Hallo zusammen,

ich habe eine CSV-Datei, in der sich in einer bestimmten Spalte, Aufzählungspunkte mit Text befinden. Diese sind
als HTML-Code vercoded.

In Excel kann ich das jetzt prinzipiell leicht bearbeiten.
Man markiert die entsprechende Spalte, geht auf "Suchen und Ersetzen", gibt "<*>" ein und
schon sind alle Codes draußen.

Das Problem ist, dass diese CSV-Datei aus einem ERP-System erzeugt wird und ich
mittels Batch-Datei automatisiert diese CSV-Datei bearbeiten muss und dadurch die
HTML-Codes entfernt werden müssen.

Kann mir einer sagen, wie ich diesen Code aufbaue?

Schon jetzt vielen Dank für Eure Hilfe. Ich bin für jeden Hinweis dankbar.

Gruss
Jörg

Please also mark the comments that contributed to the solution of the article

Content-Key: 358092

Url: https://administrator.de/contentid/358092

Printed on: April 19, 2024 at 23:04 o'clock

10 Comments

Latest comment

Hi,
can be done with a single line of code

powershell -ExecutionPolicy ByPass -Command "(Import-csv 'C:\file.csv' -Delimiter ';') | %%{$_.'ColumnName' = $_.'ColumnName' -replace '^.*|<[^>]+>|[\r\n]+','';$_} | export-csv 'C:\file.csv' -Delimiter ';' -NoType -Encoding UTF8"  

Filenames, CSV-Delimiter and ColumnName where the HTML string is stored need to be adjusted.

Regards
Tom

Dear Tom,

first - thank you for your help.

I tested it, but it doesn't work. Maybe I did something wrong.
Could you help me again?

Please see the message which I got back.

//Fehlende schließende ")" im Ausdruck.
Bei Zeile:1 Zeichen:91
+ (Import-csv C:\Users\xxxxxxxxx\Desktop\filename.csv -Delimiter <<<< ;) | \Users\xxxxxxxxx\Desktop\filename.csv -Delimiter ';' -NoType -Encoding UTF8
+ CategoryInfo : ParserError: (CloseParenToken:TokenId) , Paren
tContainsErrorRecordException
+ FullyQualifiedErrorId : MissingEndParenthesisInExpression

Thank you in advance for your help.

Best regards,
Jörg

Sorry, small typo, is corrected above.

For your information, this line has to be used inside a Batchfile, because percent signs are doubled, otherwise you have to replace the double percent signs with a single one..

Dear Tom,

wow - that works. You are great - thank you.

The result is "nearly" perfect, but:
could you extend your command to delete after removing the html codes also the first line into that cells and also delete all line breaks into that cells?

Again thank you in advance for that final question.

Best regards,
Jörg

Done.

Dear Tom,

I got following error message:

Fehlende schließende ")" im Ausdruck.
Bei Zeile:1 Zeichen:182
+ (Import-csv C:\Users\XXXXXX\Desktop\filename.csv -Delimiter ';') | %{$_.ItemTechnicalFeatures = ($_.ItemTechnicalFeatures -replace '<[^>]+>|[\r\n]+','' <<<< ;$_} | export-csv C:\Users\XXXXXX\Desktop\filename.csv -Delimiter ';' -NoType -Encoding UTF8
+ CategoryInfo : ParserError: (CloseParenToken:TokenId) , Paren
tContainsErrorRecordException
+ FullyQualifiedErrorId : MissingEndParenthesisInExpression

Do you have an idea where the problem is?

Again thank you ...

Rgds,
Jörg

Damn, my fingers are way too cold today

. Typo is corrected, sorry again.

Dear Tom,

please don't say sorry. It is so great that you help me. It works phantastic. Thank you very very much.
That was great and perfect.

Best regards,
Jörg

Glad it helped you

.

Have a nice day.
Tom

Dear Tom,

could you help me also on that here?

Suche Skript für Batch-Datei, um eine Spaltenbezeichnung innerhalb einer CSV-Datei umzubenennen

Rgds,
Jörg

German solved Question Batch, Shell Development

Hotly discussed

Check of ZFW Firewallgleixnerd - 3 Comments

How to set up and configure a Linux GRE tunnelAlexWisha - 3 Comments

WIREGUARD VPN ON UDM PRO BEHIND FRITZBOX - HANDSHAKE DID NOT COMPLETEjstricker - 3 Comments

End of Support dates for Office 2016, 2019 Apps und Productivity ServersDani - 1 Comment