Macro Script for finding a character

Hello,

I have a spread sheet which looks like below

Program: STK4R01 C:\LM90\STK4R01 Block: _Main
05-31-10 13:18 GE FANUC SERIES 90-70 (v7.05) Page 99


|[ START OF LD PROGRAM STK4R01 ] (* *)
|
|[ VARIABLE DECLARATIONS ]

V A R I A B L E D E C L A R A T I O N T A B L E

REFERENCE NICKNAME REFERENCE DESCRIPTION
--------- -------- --------------------------------
%I00001 LTD HSC Strobe1 STATUS
%I00002 LTD HSC Strobe2 STATUS


Program: STK4R01 C:\LM90\STK4R01 Block: DPILE
05-31-10 13:18 GE FANUC SERIES 90-70 (v7.05) Page 99

+[ START OF LD BLOCK DPILE ]
|
|[ VARIABLE DECLARATIONS ]

V A R I A B L E D E C L A R A T I O N T A B L E

REFERENCE NICKNAME REFERENCE DESCRIPTION
--------- -------- --------------------------------
%L00001 D PILE INNER SLEW POS
%L00003 D PILE OUTER SLEW POS


I want to get the block name and prefix all the % ones with the block name.

For example if the Block name is _Main
then all the reference coloumns will become _main.%L00001

then it will look for the next block name and if its diff all the reference block will have the reference name assoicated with the prefix of the block name.


Please help me out on the same.Its urgent.