Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert character using Regex
Hi,
Please have a look at the three strings below which are in 3 cells in a column. These are portions of longer strings. KR_Prod-Tlk-Np#-ll 1189S11 @as-BBAla#- 00000789384 SP-17700IOOI KR_Prod-Tlk-Np#-111189fflI@as-BBAla#- 00000788938 RELIANCE FINANCIAL KR_Prod-Tlk-Np#-l42000#lI @as-BBAla#- 00000789401BHARTIA-3316776111 Using Regex and VBA, I want to add a "~" character after the "384" in the first line, "938" in the second line and "401" in the third line ie to get the following output. (Regex Buddy gave the following regular expression "BBA.*?\d{11}" to match the pattern. Am not sure that it would work in VBA.). I am new to regular expressions, but feel that they would be the right approach to solving problems of this type. KR_Prod-Tlk-Np#-ll 1189S11 @as-BBAla#- 00000789384~ SP-17700IOOI KR_Prod-Tlk-Np#-111189fflI@as-BBAla#- 00000788938~ RELIANCE FINANCIAL KR_Prod-Tlk-Np#-l42000#lI @as-BBAla#- 00000789401~BHARTIA-3316776111 The pattern that is to be matched is "BBA followed by any characters, followed by 11 numerical characters" or something other such pattern that precisely determines the location of the "~" as above. I will then use this knowledge to add more "~" characters in the string using other Regex patterns. Thanks in advance for the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Tab Character | Excel Programming | |||
how to insert tab character into the cell? | New Users to Excel | |||
Insert Character into Editing-Cell | Excel Programming | |||
Insert Character in a String | Excel Programming | |||
Insert a special character before and after a word | Excel Discussion (Misc queries) |