I have some data in CSV file, say
data.csv with columns age, sex, country and status. Is it possible I could encrypt the entire CSV file some way which allows me to fetch only selected columns, say country and status, from the encrypted file and then decrypt to get back only those fields in clear text?
I am talking something similar to column-based encryption available in some databases but I cannot use any databases.
One idea I have is while encryption i encrypt each field column one by one, put a delimeter and then encrypt other field and append to the previously encrypted field but i am certain its a bad approach.