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.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

michaeldlkiper

New Member
Joined
Apr 9, 2012
Messages
2
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 "
 

Watch MrExcel Video

Forum statistics

Threads
1,098,858
Messages
5,465,106
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top