[SOLVED] "grep" a csv file including multi-lines fields?

Issue

file.csv:

XA90;"standard"
XA100;"this is
the multi-line"
XA110;"other standard"

I want to grep the "XA100" entry like this:

grep XA100 file.csv

to obtain this result:

XA100;"this is
the multi-line"

but grep return only one line:

XA100;"this is

source.csv contains 3 entries. The "XA100" entry contain a multi-line field. And grep doesn't seem to be the right tool to "grep" CSV file including multilines fields.

Do you know the way to make the job ?

Edit: the real world file contains many columns. The researched term can be in any column (not at begin of line, nor at the begin of field). All fields are encapsulated by ". Any field can contain a multi-line, from 1 line to any, and this cannot be predicted.

Solution

Using PS response, this works for the small example:

sed 's/^X/\n&/' file.csv | awk -v RS= '/XA100/ {print}'

For my real world CSV file, with many columns, with researched term anywhere, with unknown count of multi-lines, with characters " replaced by "", with multi-lines lines beginning with ", with all fields encapsulated by ", this works. Note the exclusion of the second character " in sed part:

sed 's/^"[^"]/\n&/' file.csv | awk -v RS= '/RESEARCH_TERM/ {print}'

Because first column of any entry cannot start with "". First column allways looks like "XXXXXXXXX", where X is any character but ".

Thank you all for so much responses, maybe others solutions are working depending the CSV file format you use.

Answered By - Guillaume