Honda-Acura.net

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

office help

Thread Tools
 
Old 08-01-2007, 08:36 AM
  #1  
Red X
x pǝɹ
Thread Starter
 
Red X's Avatar
 
Join Date: Feb 2003
Location: Upstate
Posts: 6,246
Likes: 0
Received 1 Like on 1 Post
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.
Red X is offline  
Reply Like
Old 08-01-2007, 08:40 AM
  #2  
bnuk
Senior Member
 
bnuk's Avatar
 
Join Date: Feb 2003
Location: pittsburgh.
Posts: 1,863
Likes: 0
Received 0 Likes on 0 Posts
Default
what kind of file? i'm assuming excel. a pretty simple macro should do it.
bnuk is offline  
Reply Like
Old 08-01-2007, 08:51 AM
  #3  
thomas
pew pew pew
 
thomas's Avatar
 
Join Date: Jan 2005
Location: teh az
Posts: 6,437
Likes: 0
Received 0 Likes on 0 Posts
Default
what linux program does that?
thomas is offline  
Reply Like
Old 08-01-2007, 08:54 AM
  #4  
bnuk
Senior Member
 
bnuk's Avatar
 
Join Date: Feb 2003
Location: pittsburgh.
Posts: 1,863
Likes: 0
Received 0 Likes on 0 Posts
Default
oh is that just lines of text? Can you do VB at all?
bnuk is offline  
Reply Like
Old 08-01-2007, 08:57 AM
  #5  
Red X
x pǝɹ
Thread Starter
 
Red X's Avatar
 
Join Date: Feb 2003
Location: Upstate
Posts: 6,246
Likes: 0
Received 1 Like on 1 Post
Default
its office word

and with linux I could use sed/awk/grep commands to parse the file.
Red X is offline  
Reply Like
Old 08-01-2007, 08:58 AM
  #6  
Red X
x pǝɹ
Thread Starter
 
Red X's Avatar
 
Join Date: Feb 2003
Location: Upstate
Posts: 6,246
Likes: 0
Received 1 Like on 1 Post
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?
Red X is offline  
Reply Like
Old 08-01-2007, 09:00 AM
  #7  
thomas
pew pew pew
 
thomas's Avatar
 
Join Date: Jan 2005
Location: teh az
Posts: 6,437
Likes: 0
Received 0 Likes on 0 Posts
Default
vim for windows has a find and replace function


EDIT: Nm that wont work
thomas is offline  
Reply Like
Old 08-01-2007, 09:01 AM
  #8  
Red X
x pǝɹ
Thread Starter
 
Red X's Avatar
 
Join Date: Feb 2003
Location: Upstate
Posts: 6,246
Likes: 0
Received 1 Like on 1 Post
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.
Red X is offline  
Reply Like
Old 08-01-2007, 09:02 AM
  #9  
bnuk
Senior Member
 
bnuk's Avatar
 
Join Date: Feb 2003
Location: pittsburgh.
Posts: 1,863
Likes: 0
Received 0 Likes on 0 Posts
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.
bnuk is offline  
Reply Like
Old 08-01-2007, 09:02 AM
  #10  
Red X
x pǝɹ
Thread Starter
 
Red X's Avatar
 
Join Date: Feb 2003
Location: Upstate
Posts: 6,246
Likes: 0
Received 1 Like on 1 Post
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.
Red X is offline  
Reply Like



Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT -8. The time now is 04:00 PM.