Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
crack this!!
I need a clever Trevor to help me crack the following regular expression find-replace issue (I think...): I have the following 3 columns in an excel sheet. Using the 1st row as an example, Column 1 reads -arrItems1[0] = "- Column 2 reads -Aberdeen ";- Column 3 reads -arrItemsGrp1[0] = 1;- As below: arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1; arrItems1[0] = " Addo "; arrItemsGrp1[0] = 1; arrItems1[0] = " Adelaide "; arrItemsGrp1[0] = 1; arrItems1[0] = " Alexandria "; arrItemsGrp1[0] = 1; arrItems1[0] = " Alice "; arrItemsGrp1[0] = 1; arrItems1[0] = " Aliwal North "; arrItemsGrp1[0] = 1; arrItems1[0] = " Balfour "; arrItemsGrp1[0] = 1; I need to replace in column 1 and colum 3, the number in the [] 's to increment by one in the next row: arrItems1[0] = " Aberdeen "; arrItemsGrp1[0] = 1; arrItems1[1] = " Addo "; arrItemsGrp1[1] = 1; arrItems1[2] = " Adelaide "; arrItemsGrp1[2] = 1; arrItems1[3] = " Alexandria "; arrItemsGrp1[3] = 1; arrItems1[4] = " Alice "; arrItemsGrp1[4] = 1; arrItems1[5] = " Aliwal North "; arrItemsGrp1[5] = 1; arrItems1[6] = " Balfour "; arrItemsGrp1[6] = 1; Your knowledge will be much appreciated!! Thanking you in anticipation! -- theonlymac ------------------------------------------------------------------------ theonlymac's Profile: http://www.excelforum.com/member.php...o&userid=32444 View this thread: http://www.excelforum.com/showthread...hreadid=522242 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Crack | Excel Discussion (Misc queries) | |||
How hard is it to crack a password that's been set for a Word or . | Excel Discussion (Misc queries) | |||
excel password crack | Excel Discussion (Misc queries) |