Home / Questions / 334682
Accepted
carallot
Asked: 2020-03-06 03:38:54 +0800 CST 2020-03-06 03:38:54 +0800 CST

replace text in CSV

  • 772

I am exporting some tables DBFthrough CSVlibreoffice. This in the headers, it exports the name of the header plus characters that refer to the data type and length for example, the NNUMALB column , it exports it to me as NNUMALB,N,7,0 and I want to do a massive replacement that eliminates me everything from the first comma. Can you give me a cable? Thank you very much.

regex

1 Answers

  1. Best Answer

    This, replace regular expression ,.*with '' (nothing)

    enter image description here

    it worked for me

    The expression selects all characters beginning with "," and replaces them with an empty character. "." denotes any character and "*" is the quantifier "everything that follows from here on out"

    • 1