View Single Post
 
Old 05-07-2012, 02:02 AM
Jasa P Jasa P is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2012
Posts: 13
Jasa P is on a distinguished road
Default VBA code for adding slash (/)

Hi, I'm needing some help to solve my problem:
1. As you see below, each section of line is separated by slash sign (/)
2. The problem is sometimes I forget to add slash or make mistakes by adding other codes, ex: comas (,), space ( ), etc.
If I check them back and fix them one by one, it require a lot of time and there's still chance to lose them.

I'm wondering for any help in this problem. I need VBA code for adding slash at the end of each section: after (x)+number or dot (.)+numbers of each section

Would you mind to help me? Any help would be great.

SAMPLE DATA
*note: ^t --> tab character
Quote:
S01=02^t45.01.39.05x245.201.939.905.01.45.39.05.37 .73/01.30.66.00.28.64x74.45.5.10


L01=03^t0266x2/2066x2/6066x2/6766x2/266x3/066x3/766x3/66x10/15x5/51x5/11x5/16x5/516x5/99x5


L02=04^t06x5.60.5.2.5/20x5.5.5.50.5.3.3


B01=05^t62.58.75.85.26.08.80.45.42x2.54.72.15.299. 8.15.63.57.5/50x7.56.45.30.90.4/06.76.16.86.24x4/439.39x6/49.94.15.51x100


B02=07^t29.92.26.62.36.63.46.64.59x3.95.6/278.295.241.277x244.248.2/78.95.85.41.77.44x4.53.2/578.578.539x2/78.76.39x4/13.25.52.28.82.18.81x6
I'm using Word 2007, Windows XP for PC, and Windows 7 for notebook


Regards,



Jasa

Last edited by Jasa P; 05-08-2012 at 01:07 AM.
Reply With Quote