Questions tagged [non-alphanumeric]
65 questions
0
votes
0 answers
SQL Convert from alphanumeric to numeric only
Ok, I have a table I am querying for an outside project. The table has a field that is alphanumeric but the external project can only support numeric data. The outside project is needing my data as an Excel spreadsheet so I am trying to just…

Jayson
- 73
- 2
- 2
- 9
0
votes
2 answers
Extract numbers from number records and pass null to alphanumeric in Postgresql
I have a test table in Postgresql. It has a field value_exist which is a string but it has alphanumeric values in it and some special characters in the data. I want to ignore the characters [/alpha/?/$/encoding/.] in it and check if the record has…

user1538020
- 515
- 1
- 9
- 25
0
votes
1 answer
Use IF operator to diverge actions on alphanumeric and non-alphanumeric elements in a given array
I need help working on arrays that can contain both ALPHANUMERIC and NON-ALPHANUMERIC elements.
I need to perform an action for ALPHANUMERIC, and a different action for NON-ALPHANUMERIC.
I have been trying different ways to declare the statement If…

jordivilagut
- 333
- 2
- 9
0
votes
2 answers
How to query for strings that have apostrophes or any kind of non-alphanumeric characters
I am trying to run some database queries with SQLAlchemy. But I am having an issue querying for strings that have apostrophes or any kind of non-alphanumeric character.
For example: test = "I\'ve"
I used:
matchList =…

python
- 4,403
- 13
- 56
- 103
0
votes
1 answer
How do you make a pyglatin translator that doesnt recognize nonaplha characters?
i need my pyglatin translator to return 'ellohay, orldway.' when i input 'Hello, world.' however i a unsure of what code needs to be inserted t make it do what i want. this is what i have so far;
pyg = 'ay'
input = raw_input("Please enter a…
0
votes
1 answer
How to make Java regex to replace non-alphabetic signs and add underscores in Java class names?
I am generating Java classes from input which represents some model language.
Customer who creates input models, doesn´t care about Java, so sometimes I get this kind of names of classes:
1) Struct+
2) Controller:
3) *
Obviously, this is not…

MartinC
- 55
- 8
0
votes
2 answers
RegEx match word in string containing + and - using re.findall() Python
myreg = r"\babcb\"
mystr = "sdf ddabc"
mystr1 = "sdf abc"
print(re.findall(myreg,mystr))=[]
print(re.findall(myreg,mystr1))=[abc]
Until now everything works as expected but if i change my reg and my str to.
myreg = r"\b\+abcb\"
mystr = "sdf…

gabrielK
- 19
- 1
- 2
0
votes
1 answer
non-alphanumeric (ex semicolon) in connectionstring
Ive searched all over the web for a simple solution to my problem, but I find it weird that no one has some up with a way to "get a correct connection string if the password contains non-alphanumeric characters".
My problem:
I have a user which has…

Thomas
- 11
- 3
0
votes
2 answers
How to Ignore Letters After Numbers In An Array
I am currently using this code to display the final child in a hierarchical taxonomy. For example, a post tagged 20th Century > 1990s > 1994 should ultimately only show 1994.
The code below works for most Parent/Child groups except for ones that…

ddxv
- 23
- 5
0
votes
2 answers
Regular expression to match all non-alphanumerics except apostropes in contractions
I'm trying to tokenize a string of English text such that I can get a sequence of the words without any punctuation, but at the same time I want to leave contractions (like don't and won't) and possessive nouns (like Steve's and Drew's) intact. I'm…
user1114119
0
votes
1 answer
SQL Server 2008 select statement that ignores non alphanumeric characters
I have an interesting SQL Server search requirement.
Say I have a table with Part Numbers as follows:
PARTNO DESCRIPTION
------ -----------
ABC-123 First part
D/12a92 Second Part
How can I create a search that will return results if I…

alcomcomputing
- 307
- 1
- 4
- 17
0
votes
7 answers
Check if a string contains a non-alphanumeric character
I am trying to write a function which takes a string as an argument and checks if that string contains only one non-alphanumeric character, if this is the case then return true, if not, return false.
For example:
'Alex's' would return true.…

James Warner
- 147
- 4
- 4
- 11
0
votes
3 answers
How to deal with non alpha numeric characters asp.net vb?
I am processing a lot of CSV files that have people data and occasionally names are used non-alpha numeric characters like á and those all become � symbols in the datatable. How do i prevent this problem ? I just wanna leave all the names as they…

Laurence
- 7,633
- 21
- 78
- 129
0
votes
2 answers
Removing non-alpanumeric characters from an ordered collection of objects (list) in R
I have a question about removing non-alphanumeric characters from a list in R. I have a list will all sorts of odd characters, blanks, etc. and would like to remove them. I'm generally able to remove what I want using the tm package in r. I fiddled…

Tom
- 17
- 2
- 6
-1
votes
2 answers
creating mercurial repo in directory whose name has dollar signs
I am trying to create a mercurial repository in a directory whose name includes dollar signs. This is an equivalent and simplified example of what i get on windows 10 cmd.exe with mercurial 4.1.3 :
C:\test\dir1>hg init
C:\test\dir1>hg…

Dan Wasson
- 21
- 4