Issue with copying formulated data from Excel into Notepad.

[michaeldlkiper]

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.

 

[michaeldlkiper]

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 "