Remove Commas From End Of String

Using ASP/VB I need to remove unwanted commas from the end of a field
that will be use in an array. There are items in the field that are
comma separated, so I don't want to remove them, just the end ones,
could be anywhere up to 5 unwanted commas.

Any ideas?

View Replies


ADVERTISEMENT

Import From Csv - Remove Commas

I'm importing data from a csv file but have the following problem.

It see any comma in a specific column as the end of the current column and move the rest of the values into the next column I.E Data from column 4 display as data from column 5.

I do know that it's comma delimited but would like to know if there's no way that I can distinguish between the commas in a column and the commas that indicate a new column.

Col1 Col2 Col3 Col4 Col5
Value Value Value Val,ue Value


How do they do it in excel?

View Replies View Related

Remove Commas And Space

let say i got a string:

apple, orange, durian

how to check got how many commas in this string? how to check beside the commas is space or not space? if the words beside the commas is space, i wan to remove the space? if the words got commas, i have to remove the space.

View Replies View Related

String With Commas, How To Use Instr And Mid Function In A Loop?

I have a string --> 7,8,9,10. This string may contain more or less than 4 numbers.
I want to separate each number and run an sql query for each number.

for example:

select * from table1 where code = '7'

select * from table1 where code ='8'

and etc....

Can I do this in a loop?

View Replies View Related

Remove Last 4 String Characters

how to take a string and output it such that the last 4 characters are removed (.txt, .pdf, .doc, etc.)

View Replies View Related

Reg Exp To Remove Part Of String

how do I get a reg exp to remove part of a string? -

I have: '/page/txtonly/index.asp' and I want to remove the '/txtonly' to end up with: '/bobby/index.asp'.

View Replies View Related

Remove Part Of String

Following java script code to get subscriber ID, its value is like 975683678-28_luxap01s.southernlinc.net, I want to leave number there and cut starting _ part, does anybody know how to remove the character starting underscore "_"? the final value is 975683678-28.
<%
subsciberID = Request.ServerVariables("HTTP_X_UP_SUBNO") ;
%>

View Replies View Related

Remove Decimal From String

I currently have a variable that is pulled from a database for currency amount. Ex: 25.99 . I need to remove the decimal place so that the variable is like 2599 instead. How can I use ASP to remove this decimal place?

View Replies View Related

Remove Last Four Characters From String

In PHP I'd use the following line:

$parsedfilename = substr($parsedfilename, -4);

But I can't find the same way to do it in vbscript using ASP!
I simply want to strip the last four characters, but leave the rest of the string in tact! As the string could be any length, I don't know a start position.

Surely it's simple and I'm missing something?

View Replies View Related

Remove Last 4 Characters From String

I have this bit of code that stores the current web page address in a Session variable. I want to always remove the last four characters, such as E.asp, or G.asp, or I.asp.

I searched tutorials on string manipulation but all seem to take out a string in the middle of a string and replace it with something. I just want the last 4 characters removed.

View Replies View Related

Search A String To Obtain Substring, Then Remove That Substring?

what I would like to do is remove a substring from a full string and display the modified string my basic code should be some like this:

strSearchString = FullString
strSearchFor = "SubString"
If InStr(1, strSearchString, strSearchFor) > 0 then
Response.write (FullString - Substring)

does anyone have any idea how I would go about doing this?

View Replies View Related

Trimming Commas

I'm dynamically building an SQL string to do an execute, and keep ending up with a leftover comma, so the string looks like this.

INSERT INTO Software ( Title, Version, Licensing, Total_Licenses, support_phone, support_email, Campuses_Licensed, Comments, support_web, FundingSource, Course_title, Subject, Grade_level, LocalExpert, ACTIVE, CATE, EntryDate,) VALUES ( 'Bob's Super Crappy Software', '4.3', 'labpack', '36', '555', '555', 'Alexander, Bilhartz, Central, Fairmeadows, Hyman, Daniel', 'James is testing this', 'www.bob.com', 'Campus PO', 'Math', 'Math', '4, 5, 6', 'Patrick Williams', '1', '0',)

Both commas are added dynamically and can be trimmed on the fly. I tried using RTRIM(strSQL, ",") but this didn't work.I put the fields into an array and tried to add only commas to all but the last entry, but that also didn't work.

View Replies View Related

CSV Commas In Data

How is the best way to handle commas in data in CSV files? I'm currently using the following:

set fso = createobject("scripting.filesystemobject")
set act = fso.opentextfile(server.mappath("filename.csv"))
itext = act.readall
arrlist = split(itext,chr(10))

and then looping through the rows and splitting at commas. However, some of the data has commas in it, which is throwing things off.

View Replies View Related

Adding Commas

4 months into the land of ASP and I still have newb questions.I have a simple string.

centertype = Type1 & Type2 & Type3 & Type4 & Type5

How do I add a comma to seperate this string? Keep in mind that some of the values may be blank.
i.e. Type1 = ""
or Type4 = ""

View Replies View Related

Replace :: Commas

I need to create a string along the lines of "23,43,78,23" with no comma at the beginning or end of it. The data comes out of a table so i've created a loop to get the data and form the string :

StrRecip = "," & objRS("number") & StrRecip

This will give me something like : ",42,78,67,2,90"

And then I've removed the leading comma :

StrRecipRem = replace(StrRecip, ",", "", 1, 1)

Is there actually a better way ?

View Replies View Related

Commas Getting Inserted Into Database

I don't know if anyone has encountered this before. I've written ASP code to insert, update and delete records from Access and SQL Server tables before but this is the first time I face this issue -

I have a form that inserts data into an Access table. For a few of the fields, commas are getting inserted into the table. If the field is left blank, there is a comma inserted. If we enter data in the field, the comma is appended to the field value (eg: smith, )

The only thing different that i'm doing here from what I've done before is I'm inserting a larger number of fields into the table - 117 fields!!

Do you think the insert statement hasn't been written correctly?

View Replies View Related

Commas Not Full Stops

I have a price field in a cms,it can deal with full stops fine, but i cant understand why it wont accept commas.

View Replies View Related

Display Data Between Commas

I would like to know if you can display only certain data into a field between commas or any other symbol without using the curshort feature. For example. I have the following.

Part, A3472, Desc: Controller: Price$ 45.00

I just need this out of it in a single form field.

A3472

I cannot use the cutshort feature because my part numbers are different lengths.

View Replies View Related

Removing Commas From Csv File

having problems removing commas from my form input. Have a form that is bringing back text strings from users. when it gets put into CSV file, any commas the user has entered get moved onto new rows.

View Replies View Related

Adding Commas To A Page Counter

I have a simple script I found that increments a number in a text file. I was wondering if anyone has a routine that will commify the number. Code:

View Replies View Related

Inverted Commas Hides Data

how to avoid an error when calling data to a text form field that contains inverted commas? When I enter "inverted commas" into a text field on a form and save to my Access database, after save the text field appears to be blank but when I look in the database it appears as entered. The problem is when the text field calls the field it doesn't show if the text is encased in inverted commas.

For instance, in my form field 'title' I enter: Big Title "Yeah" After saving the form, all that appears within the form field 'title' is: Big Title Yet the access database itself shows: Big Title "Yeah"

View Replies View Related

Display Data Between Commas In Form ASP

I would like to know if you can display only certain data into a field between commas or any other symbol without using the curshort feature. Code:

View Replies View Related

How Do I Count The Number Values Seperated By Commas

how do i count the number of values sent accross the form post seperated by commas ?

e..g 43352352,325324452,235234452,24523454

View Replies View Related

Including Inverted Commas To Specify Page Elements While Page Is In ASP

I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:

View Replies View Related

Need To Remove DAY Name

I found a simple date script, which is this:

<%
var_date=date() 'get the current date
var_date=FormatDateTime(var_date,1)
Response.Write(var_date)

Wednesday, September 29, 2004

How can I get this to not display the day of the week, I only want - September 29, 2004

View Replies View Related

Remove DAY Name

I found a simple date script, which is this:

<%
var_date=date() 'get the current date
var_date=FormatDateTime(var_date,1)
Response.Write(var_date)
%>

Wednesday, September 29, 2004

How can I get this to not display the day of the week, I only want - September 29, 2004.

View Replies View Related

Remove Dot

i have a variable which holds a value like this

stramount=Trim(Request.form("txtamount"))

response.write stramount

the output sometimes is

50.00 or
50 or
50.

if it is 50.
i want to remove the (dot) at the end. can someone tell me how to use the instr function to see if there is a dot at end and if it is there then remove it.

View Replies View Related

Remove The Gap

i have problem in removing the gap between two images, pls see the attached image. coz my item name is quite long, i dun wnat it display in horizontal, i want it display as vertical. so i create the images for the character and use ascii to recognized it.

my code is as below:

<td align="left" class="BorderLeft" width="1%">
<%dim word, pic, word1
word = "AAAAABABABBA"
pic = ""
for i = 0 to len(word)-1
word1 = cstr(right(left(word,len(word)-i),1))
pic = asc(word1) & ".gif"%>
<img src="../images/<%=pic%>" border=1 vspace=0 hspace=0>
<%next%>

</td>

View Replies View Related

How To Remove Cookie?

How can I remove a cookie from the client in ASP? I'm not talking about setting the value to a blank string and I've tried this:

[vbs]
Response.Cookies("mycookie").Expires = Now()
[/vbs]
and
[vbs]
Response.Cookies("mycookie").Expires = Date() - 100
[/vbs]

Neither of which work.

Is there any way to completley remove the cookie?

View Replies View Related

Remove Header

can anyone temme the script or style sheet to remove the hearder and footer url address of the web page when printing the pag

View Replies View Related

How To Remove Duplicates

How to write asp code to remove duplicates in an array.

For Eg: A()=(1,5,10,15,10,20,5)

After removal of duplicates it should be

A()=(1,5,10,15,20).

View Replies View Related

Add Remove Button

The main idea goes like this: I have a textarea, on the right I have a listbox whose elements are loaded from an Oracle Database, I want to have an "Add" Button which when pushed will insert in the textarea the value selected on the listbox between "{ }" (ej, The {white} cat), you can add as many values as you wish and also manually edit the text, and a Submit button which open another ASP page that will check the sintax of the textarea and insert it on the Database.
So far I already have the part which checks the sintax and inserts it on the db, and the listbox with the elements you can insert on the textarea, but my boss really wants the "Add-Remove" feature and I need to finish this for Tuesday

View Replies View Related

Remove Underline

I have image icons that are clickable. I want to remove the hyperlink from around the image.
I tried the STYLE="TEXT-DECORATION: NONE" tag but thats not working. How should I remove the underline from the hypelink.
Code:


strImage = "<A target=""_blank"" href=""document.asp?job="
strImage = strImage & jobid & "&doc=" & filename & """ STYLE="TEXT-DECORATION:NONE">"
strImage = strImage & "<IMG SRC='" & GenerateIcon(rs("filename")) & "'/></A>"

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved