Solved

Insert hyphen INTO MY STRING

Posted on 2012-03-16
2
237 Views
Last Modified: 2012-03-21
hi,

I have a string with

 "NLU97PF0LO0Q6ZHL0IZZHIZAXALYLD6RU"

but what I want is this

NLU97PF0-LO0Q-6ZHL-0IZZ-HIZAXALYLD6RU

with hyphen

thanks,
0
Comment
Question by:lulu50
2 Comments
 
LVL 18

Accepted Solution

by:
nap0leon earned 500 total points
ID: 37731183
This ought to give you a feel for how to do it.

<%
str = "NLU97PF0LO0Q6ZHL0IZZHIZAXALYLD6RU"
desired = "NLU97PF0-LO0Q-6ZHL-0IZZ-HIZAXALYLD6RU"
position1 = 8
position2 = 12
position3 = 16
position4 = 20

newStr = Left(str,position1) & "-" & Mid(str,position1+1,4) & "-" & Mid(str,position2+1,4) & "-" & Mid(str,position3+1,4) & "-" & Mid(str,position4+1)

response.write(desired & "<br/>")
response.write(newStr)

%>

Open in new window

0
 

Author Closing Comment

by:lulu50
ID: 37746819
Thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
asp syntax 3 57
If-Then-Else ASP problem 6 67
Jquery Check against database on select from auto fill not working in all browsers 5 41
Designing forms 3 18
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question