I set up a form to identify the character, but the square doesnt paste.
When I opened the orig file of the phone numbers in word it did list the
numbers on single lines so it may be a newline character.
My Loop must be wrong, it's only passing one value, any suggestions would be
most appreciated.
<form action="phone_action2.cfm"
enctype="multipart/form-data"
method="post" >
<p>Enter the complete path and filename of the file to upload:
<input type="file" name="FiletoUpload" size="45">
</p>
<input type="submit" value="Upload">
</form>
<cfoutput>
<cfloop list="#FiletoUpload#"
index="i"
delimiters="chr(10) chr(13) ,">
<cfset form.phone = "#FiletoUpload#">
<cfset cleanPhone = ReReplace(form.phone, "[^0-9]", "",
"ALL")>
<cfoutput>#cleanPhone#</cfoutput>,<br />
</cfloop>
</cfoutput>
<!--- if the character string is not empty, output its ASCII value --->
<cfif IsDefined("FORM.charVals")>
<cfif FORM.charVals is not "">
<cfoutput>#Left(FORM.charVals,1)# =
#Asc(FORM.charVals)#</cfoutput>
<cfelse>
<!--- if it is empty, output an error message --->
<h4>Enter a character</h4>
</cfif>
</cfif>
<form action = "asc.cfm" method=post>
<p>Enter a character to see its ASCII value
<br><input type = "Text" name = "CharVals" size = "1" maxlength = "1">
<p><input type = "Submit" name = ""> <input type = "RESET">
</form>
-----Original Message-----
From: Charlie Griefer [mailto:charlie.grie...@gmail.com]
Sent: 2009-05-19 14:13
To: cf-talk
Subject: Re: phone formating string and removing hidden characters
just read it in doing a cffile and then do a cfloop over the content
using the newline as the delimiter (as Mark suggested). no need for
importing into a database or having to count 'x' number of characters.
you've already got the data delimited.
just loop over it and use the regex you posted earlier to remove any
non-numeric characters from each list element.
On Tue, May 19, 2009 at 11:09 AM, cfcom <cf...@aceligent.com> wrote:
>
> Mark,
>
> I think it's a newline character
> I'm thinking I have to import the list into the database. Then query it
> With the cfloop. My question is how to I set the loop to do a 10 count
> sequence?
>
> Thanks
> Steve
>
>
> -----Original Message-----
> From: Gaulin, Mark [mailto:mgau...@globalspec.com]
> Sent: 2009-05-19 13:53
> To: cf-talk
> Subject: RE: phone formating string and removing hidden characters
>
>
> That screenshot looks like a newline character (or is it a linefeed?) as
> shown by an editor that was expecting a more Windows-ly standard line
> ending. Other editors (like EditPad) would probably show each phone
> number on its own line.
>
> Anyway, you can use cf's "asc()" method to find the actual value of the
> Nth character (the one that shows up as a box) and then you'll know what
> delimiter to use with the list functions. (I bet the character is 10 or
> 13, so you could try to set a delimiter of chr(10) or chr(13) and see
> what happens.)
>
> Once you know the delimited you can use a list function like <cfloop
> list=".." delimiter=".."> or ListToArray(list, delimiter) to convert
> your file content to individual lines. (You have lots of options... The
> key is figuring our what delimiter to use.)
>
> Thanks
> Mark
>
> -----Original Message-----
> From: cfcom [mailto:cf...@aceligent.com]
> Sent: Tuesday, May 19, 2009 1:23 PM
> To: cf-talk
> Subject: phone formating string and removing hidden characters
>
>
> Hi,
>
> I have a text file of 100,000 plus phone numbers that I need to change
> formatting and export to a clean list. There is an unusual hidden
> character that doesn't appear when pasting. Here is a screen shot
> http://www.aceligent.com/post/hidden.html
>
> The list is compiled in this manner, 'X' is supplemented for where the
> hidden character is:
> 212,2000876x212,2002686x212,2005799x212,2007697x212,2010062x212,2010087x
> 212,
> 2010112x212,2010192x212,2010237x212,2010306x212,2010326x212,2010710x212,
> 2010
> 714x212,2010740x212,2010754x212,2010800x212,2010978x212,2011063x212,2011
> 065x
>
> I need to process the list as a batch. How would I adapt this to clean
> and count a 10 number sequence; add a coma; and repeat on new line? Then
> export as a text file.
>
> <cfset form.phone = "#form.phoneinput#"> <cfset cleanPhone =
> ReReplace(form.phone, "[^0-9]", "", "ALL")>
> <cfoutput>#cleanPhone#</cfoutput>
>
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322654
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
