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…
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