Delete everything before a double quote

Question

I'm trying to clean a CSV file which has a column with contents like this:

Sometexthere1", "code"=>"47.51-2-01"}]

And I would like to remove everything before the first quote (") in order to keep just this:

Sometexthere1

I know that I can use $` to get everything before some match in regex, but I am not understanding how to keep just the string before the first double quote.

Answer 1

You probably mean "delete everything after a double quote"? In Open Refine, you can use this GREL formula :

value.replace(/".+/, "")


> Result : Sometexthere1

Answer 2

Parameter expansion does this well enough:

# Define a variable
s='Sometexthere1", "code"=>"47.51-2-01"}]'

# expand it, removing the longest possible match (from the end) for '"'*
result=${s%%'"'*}

# demonstrate that result by printing it
printf '%s\n' "$result"

...properly returns Sometexthere1.