Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

double code

Hi,
I have record coming as below in as below
"123", "T120 20" TFT Monitors" ,"KBC"
"234"," My name is sam","ABC"

i want to double code to be doubled something like below See double quote after "20":

"123", "T120 20"" TFT Monitors" ,"KBC"
"234"," My name is sam","ABC"

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lhademmor
lhademmor
If the first part of line tells something about the next part then use regular expresions.
EG if 123 always means a product and 234 means an name. The just copy the name line as is like in Your example and use re's to find point of separation and then add the ". An easier to understand but slower way is to char run the line and then add the " when at the seperation point.

If this is not usefull to You i would guess that people in here would like a little more info on You problem :-) eg give a bit larger examble

Sincerely
  Klavs.
Avatar of Member_2_276102
Member_2_276102
Is this a specific record? Or is it an example of records that have just a single unmatched double-quote in the 2nd field? Is it always the 2nd field?

Tom