Honda-Acura.net

Notices
The Basement Non-Honda/Acura discussion. Content should be tasteful and "primetime" safe.

office help

Thread Tools
 
Old Aug 1, 2007 | 08:36 AM
Share
  #1  
Red X's Avatar
Red X
Thread Starter
x pǝɹ
 
Joined: Feb 2003
Posts: 6,246
Likes: 1
From: Upstate
Default office help
This is the one time I wish I had linux.

Anyone know of a windows program or of a way in office to replace all occurrences of references with a linear addition?

For example:

I need to add +4

[1],[4],[5-9] -> [5],[8],[9-13]

Thanks.
Reply
0
Old Aug 1, 2007 | 08:40 AM
Share
  #2  
bnuk's Avatar
bnuk
Senior Member
 
Joined: Feb 2003
Posts: 1,863
Likes: 0
From: pittsburgh.
Default
what kind of file? i'm assuming excel. a pretty simple macro should do it.
Reply
0
Old Aug 1, 2007 | 08:51 AM
Share
  #3  
thomas's Avatar
thomas
pew pew pew
 
Joined: Jan 2005
Posts: 6,437
Likes: 0
From: teh az
Default
what linux program does that?
Reply
0
Old Aug 1, 2007 | 08:54 AM
Share
  #4  
bnuk's Avatar
bnuk
Senior Member
 
Joined: Feb 2003
Posts: 1,863
Likes: 0
From: pittsburgh.
Default
oh is that just lines of text? Can you do VB at all?
Reply
0
Old Aug 1, 2007 | 08:57 AM
Share
  #5  
Red X's Avatar
Red X
Thread Starter
x pǝɹ
 
Joined: Feb 2003
Posts: 6,246
Likes: 1
From: Upstate
Default
its office word

and with linux I could use sed/awk/grep commands to parse the file.
Reply
0
Old Aug 1, 2007 | 08:58 AM
Share
  #6  
Red X's Avatar
Red X
Thread Starter
x pǝɹ
 
Joined: Feb 2003
Posts: 6,246
Likes: 1
From: Upstate
Default
Originally Posted by bnuk
oh is that just lines of text? Can you do VB at all?
I've never gotten down to the the VB level in word - I kinda don't have time to mess around with programming it (as simple as it is, I get side-tracked very easily); is there a simpler solution?
Reply
0
Old Aug 1, 2007 | 09:00 AM
Share
  #7  
thomas's Avatar
thomas
pew pew pew
 
Joined: Jan 2005
Posts: 6,437
Likes: 0
From: teh az
Default
vim for windows has a find and replace function


EDIT: Nm that wont work
Reply
0
Old Aug 1, 2007 | 09:01 AM
Share
  #8  
Red X's Avatar
Red X
Thread Starter
x pǝɹ
 
Joined: Feb 2003
Posts: 6,246
Likes: 1
From: Upstate
Default
Originally Posted by bnuk
what kind of file? i'm assuming excel. a pretty simple macro should do it.
If it was excel it'd be awesome. But its a technical paper and I'm combining multiple papers with different cited sources and their numbers need to match up.
Reply
0
Old Aug 1, 2007 | 09:02 AM
Share
  #9  
bnuk's Avatar
bnuk
Senior Member
 
Joined: Feb 2003
Posts: 1,863
Likes: 0
From: pittsburgh.
Default
I would spit one out for you but I've only ever worked with excel, im not sure how you read text from a text file.
Reply
0
Old Aug 1, 2007 | 09:02 AM
Share
  #10  
Red X's Avatar
Red X
Thread Starter
x pǝɹ
 
Joined: Feb 2003
Posts: 6,246
Likes: 1
From: Upstate
Default
Originally Posted by hector200
vim for windows has a find and replace function


EDIT: Nm that wont work
I can use word, sort of, but their find and replace is awkward at best and they don't have mathematical commands since everything is text based - so adding 4 is just improper and confuses the shit out of the program.
Reply
0



Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT -8. The time now is 05:15 AM.