on 09-28-2016 3:54 AM
Hey All,
I have a input string like below:
inputString = "Description[1] Product or Service Code. Description[2] Cost Center Code. Description[3] Profit Center Code....Description[n]".
where n = 1 to 9999
I need outputstring string like below
outputString = "Description[1] Product or Service Code. Cost Center Code. Profit Center Code"
So basically, other than the first Description[1] i need to replace all the occurrences of Description[n] with blank.
Can someone please help me with the UDF on how to achieve this.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.