Stripping quotes from around fields. 1

[cuttersw]

Can anyone suggest a simple way to only return data that exists between quotes within a field.

EG of data set:

[tt]
Mailbox}@{JohnD}@{John Doe}@{john.doe@domain.com%jd@domain.com%jd@dom2.com}@{y
Mailbox}@{MaryS}@{“Smith, Mary”}@{smithm@domain.com}@{y
Mailbox}@{BudH}@{Bud Holly}@{BudH@domain.com%bud.holly@domain2.com}@{y
[/tt]
[small]The FieldDelimiter is "}@{"[/small]

Notice that the 3rd field of the 2nd record is embedded in quotes.

Currently I am using a combination of substr() and index() functions to remove the quotes but its messy and slow!


Regards,

Shaun

 

[cuttersw]

...I have managed to improve the above to this:

[tt] mbname=$3
if (mbname ~ /^\"/) {
split($3,xxx,"\"")
mbname=xxx[2]
}[/tt]

Is that as efficent as it gets or am i still missing a simpler solution?

 

[futurelet]

  mbname=$3
  gsub( /^"|"$/, "", mbname)

 

[cuttersw]

Ahhhhh - that's much better!

- Thanks very much futurelet.