delete spaces

[Guest]

Hi i have a string of text and numbers which i want to insert into a table colum


(ApID)
values
('#ClubID##First##Sur##Phone#')

but i need to remove any spaces that may occur how can i do this inside the insert query?

[cf_dev2]

Look at the Replace function

#Replace(variableName, " ", "", "all")#

[Guest]

ok thanks i have

<cfset first = #Replace(firstName, " ", "", "all")# >
<cfset sec = #Replace(surName, " ", "", "all")# >
<cfset all = #show.id#show.phone##first##sec# >

but i think i am getting a carrage return somehere, so what i now need is to remove any - & / \ charicters and any spaces and any carrage returns so i get a nice alpha numeric value.

how can i do this?

[cf_dev2]

... or if you want only alpha-numeric values, try RegExReplace(). I don't know the exact syntax offhand. Something like

#reReplaceNoCase(theString, "[^0-9,a-z]", "", "all")#

[Guest]

ok thanks i am using

#reReplaceNoCase(getit.ClubID, "[^0-9,a-z]", "", "all")#

but how do i add 4 columns as the string?

ie i have clubid, firstname, surname, phone which i want to add as a string

do i just use a comma between each?

[Dan_Bracuk]

The chr() function will help you. You have to put the ascii value of the carraige return inside the brackets. Google is your freind.

[cf_dev2]

> do i just use a comma between each?
No.

>but how do i add 4 columns as the string?
Same way you did in your original example.

'#ClubID##First##Sur##Phone#'