Trimming one double quote from beginning of matching field values

[mbasharat]

Hi,

I have a field name "Software" in my search results. Field values are:

"Java Development Kit 1.5
"Java Development Kit 1.7
"SUN Java Development Kit
"SUN Java Runtime Environment
Adobe Reader
Apache 1.3
.....and so values go on......

I need the double quote removed/trimmed which is present at the beginning of every value that will have them. I have tried using eval, rex with various combinations but it is not working giving error as "Unbalanced quotes"

Thanks in advance!!!!

[somesoni2 · Accepted solution]

Try like this

..| eval Software= replace(Software, "\"", "")

OR

| rex mode=sed field=Software "s/\"//g"

[mbasharat]

THANK YOU!!!