musalman
asked on
Crystal Report Replace String From Start till End Position
Hi
I need to replace some sub-string from string on the basis of some condition.
First check my string
"Sandwich Panel cutback/end lap = 0 Outer Skin Profile: TSP35/205, AZ-0.7mm, Finish:POLYSTER Painted Color:FW, PU Core: 50mm thk, Density:35/40 Kg/M3 Inner Skin Profile: FLAT, AZ-0.5mm, Finish:POLYSTER Painted Color:MF "
Here, I want to replace only 'Finish:POLYSTER Painted' that is adjacent to Color:MF.
I used replace function but it replaces both occurences. The above string may take more then 2 occurences of Finish:POLYSTER Painted Color:XX
Hope you all will be clear with my problem.
I need to replace some sub-string from string on the basis of some condition.
First check my string
"Sandwich Panel cutback/end lap = 0 Outer Skin Profile: TSP35/205, AZ-0.7mm, Finish:POLYSTER Painted Color:FW, PU Core: 50mm thk, Density:35/40 Kg/M3 Inner Skin Profile: FLAT, AZ-0.5mm, Finish:POLYSTER Painted Color:MF "
Here, I want to replace only 'Finish:POLYSTER Painted' that is adjacent to Color:MF.
I used replace function but it replaces both occurences. The above string may take more then 2 occurences of Finish:POLYSTER Painted Color:XX
Hope you all will be clear with my problem.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.