Issue with copying formulated data from Excel into Notepad.

michaeldlkiper

New Member
Joined
Apr 9, 2012
Messages
2
MrEXCEL Members,

In need of your help, I have a workbook that we created for to produce codes for a unix server for bulk loading.

the issue is, when we enter the information in to the cells that need information entered, and copy the populated cell data, paste it into notepad, it puts " on the beginning portion and the very end portion. also when we enter a single ' it removes them so we have to enter ' two times to get 1 ( ' ) in the data.

Here is the data from page 2 which it pulls from to the formula on page one where the information is entered.



-- removed inline image ---

<table border="0" cellpadding="0" cellspacing="0" width="1125"><colgroup><col style="mso-width-source:userset;mso-width-alt:41142; width:844pt" width="1125"> </colgroup><tbody><tr style="height:45.0pt" height="60"> <td class="xl63" style="height:45.0pt;width:844pt" height="60" width="1125">Insert into IDM_SYNC_GEIDM_ENTITLEMENT (PERSON_NUM_SSO,APP_NAME,REQUEST_ID,ENTITLEMENT_ID,ENTITLEMENT_ATTRIBUTE,ENTITLEMENT_KEY,ENTITLEMENT_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values (</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:844pt" height="20" width="1125">','unix2','-1',(select max(entitlement_id) from idm_sync_geidm_entitlement),</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:844pt" height="20" width="1125">'container','container','</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt" height="20">'netgroup','netgroup','</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt" height="20">'server','server','</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt" height="20">'account_id','account_id','</td> </tr> <tr style="height:30.0pt" height="40"> <td class="xl63" style="height:30.0pt;width:844pt" height="40" width="1125">',sysdate,'Manual_Load',sysdate,'Manual_Load');
</td> </tr> <tr style="height:45.0pt" height="60"> <td class="xl65" style="height:45.0pt;width:844pt" height="60" width="1125">
commit;
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:844pt" height="20" width="1125">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:844pt" height="20" width="1125">','unix2','-1',(select max(entitlement_id) +1 from idm_sync_geidm_entitlement),</td> </tr> </tbody></table>


this is the formula from page one when information is entered into the required areas on page 1: Insert into

-- removed inline image ---


WHICH LOOKS LIKE THE BELOW.

<table border="0" cellpadding="0" cellspacing="0" width="328"><colgroup><col width="328"></colgroup><tbody><tr height="20"> <td class="xl65" style="height:15.0pt;width:246pt" height="20" width="328">Insert into IDM_SYNC_GEIDM_ENTITLEMENT (PERSON_NUM_SSO,APP_NAME,REQUEST_ID,ENTITLEMENT_ID,ENTITLEMENT_ATTRIBUTE,ENTITLEMENT_KEY,ENTITLEMENT_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values (','unix2','-1',(select max(entitlement_id) +1 from idm_sync_geidm_entitlement),'container','container','',sysdate,'Manual_Load',sysdate,'Manual_Load');

commit;

Insert into IDM_SYNC_GEIDM_ENTITLEMENT (PERSON_NUM_SSO,APP_NAME,REQUEST_ID,ENTITLEMENT_ID,ENTITLEMENT_ATTRIBUTE,ENTITLEMENT_KEY,ENTITLEMENT_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values (','unix2','-1',(select max(entitlement_id) from idm_sync_geidm_entitlement),'netgroup','netgroup','',sysdate,'Manual_Load',sysdate,'Manual_Load');
Insert into IDM_SYNC_GEIDM_ENTITLEMENT (PERSON_NUM_SSO,APP_NAME,REQUEST_ID,ENTITLEMENT_ID,ENTITLEMENT_ATTRIBUTE,ENTITLEMENT_KEY,ENTITLEMENT_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values (','unix2','-1',(select max(entitlement_id) from idm_sync_geidm_entitlement),'server','server','',sysdate,'Manual_Load',sysdate,'Manual_Load');
Insert into IDM_SYNC_GEIDM_ENTITLEMENT (PERSON_NUM_SSO,APP_NAME,REQUEST_ID,ENTITLEMENT_ID,ENTITLEMENT_ATTRIBUTE,ENTITLEMENT_KEY,ENTITLEMENT_VALUE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY) values (','unix2','-1',(select max(entitlement_id) from idm_sync_geidm_entitlement),'account_id','account_id','',sysdate,'Manual_Load',sysdate,'Manual_Load');

commit;

</td> </tr></tbody></table>


THE FINAL COPY AND PASTE OUTPUT WHEN CLICKING ON INSERT CELL IN (F) AND PASTE INTO NOTEPAD IS BELOW.

-- removed inline image ---


Could someone help on trying to find out how to have it not put " on the first part and ending? I used Word and it dosnt do that, just when pasting into notepad.
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
If needed I can email it to you or someone and see if there is something that can be put into the code formula so when its copied after all the inserts so it doesnt put "
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top