Click here to Skip to main content
15,861,125 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
AnswerRe: String Replacement Pin
Richard MacCutchan19-Sep-20 21:11
mveRichard MacCutchan19-Sep-20 21:11 
GeneralRe: String Replacement Pin
Michael Eckstein19-Sep-20 22:28
Michael Eckstein19-Sep-20 22:28 
GeneralRe: String Replacement Pin
Michael Eckstein20-Sep-20 0:19
Michael Eckstein20-Sep-20 0:19 
GeneralRe: String Replacement Pin
Michael Eckstein20-Sep-20 1:01
Michael Eckstein20-Sep-20 1:01 
GeneralRe: String Replacement Pin
Richard MacCutchan20-Sep-20 1:32
mveRichard MacCutchan20-Sep-20 1:32 
QuestionRegEx Split Pin
Member 148774747-Sep-20 7:56
Member 148774747-Sep-20 7:56 
AnswerRe: RegEx Split Pin
Richard Deeming7-Sep-20 22:43
mveRichard Deeming7-Sep-20 22:43 
Question9 million Rows in Excel Pin
IzaacSpyro30-Aug-20 22:20
IzaacSpyro30-Aug-20 22:20 
Hi,
i got an 9 million row excel file and i need to join it with another excel file base on numeric values.

Issue :

I suppose to have only unique numbers in column A, but unfortunately i got some characters in some columns.

When i try to join the two excel i get an error : dataFormat.Error: We couldnt convert number.

How can i :
1. delete rows where i got alphanumeric values in columns
2. filter out alphanumeric - powerbi, excel or any other software

Thank you
QuestionFinding a specific number in a string. Pin
Member 1086910714-Aug-20 11:36
Member 1086910714-Aug-20 11:36 
AnswerRe: Finding a specific number in a string. Pin
Richard MacCutchan14-Aug-20 21:40
mveRichard MacCutchan14-Aug-20 21:40 
GeneralRe: Finding a specific number in a string. Pin
Member 1086910715-Aug-20 1:17
Member 1086910715-Aug-20 1:17 
QuestionHow to skip a particular term in regex find and replace? Pin
usernamekiran11-Aug-20 4:34
usernamekiran11-Aug-20 4:34 
AnswerRe: How to skip a particular term in regex find and replace? Pin
Gerry Schmitz11-Aug-20 6:39
mveGerry Schmitz11-Aug-20 6:39 
QuestionFind Sequence of alphabets in the string Pin
arisaravanan11-Apr-20 1:32
arisaravanan11-Apr-20 1:32 
AnswerRe: Find Sequence of alphabets in the string Pin
Richard MacCutchan11-Apr-20 4:21
mveRichard MacCutchan11-Apr-20 4:21 
AnswerRe: Find Sequence of alphabets in the string Pin
Richard Deeming14-Apr-20 0:30
mveRichard Deeming14-Apr-20 0:30 
QuestionUsing A Regular Expression To Show Rows In Pandas (Python) Pin
Eddie Winch2-Feb-20 9:05
Eddie Winch2-Feb-20 9:05 
QuestionTSV out of a tab-based tree-like file Pin
DynV9-Nov-19 19:43
DynV9-Nov-19 19:43 
Questiongetting all the image files in a HTML Inspection Pin
Member 1463488025-Oct-19 4:03
Member 1463488025-Oct-19 4:03 
QuestionRe: getting all the image files in a HTML Inspection Pin
Richard MacCutchan25-Oct-19 4:15
mveRichard MacCutchan25-Oct-19 4:15 
AnswerRe: getting all the image files in a HTML Inspection Pin
Member 1463488025-Oct-19 9:38
Member 1463488025-Oct-19 9:38 
GeneralRe: getting all the image files in a HTML Inspection Pin
Richard MacCutchan25-Oct-19 21:57
mveRichard MacCutchan25-Oct-19 21:57 
QuestionRegular Expression To Extract Everything Including the String And Before The First Space Character Pin
Member 1457241529-Aug-19 14:46
Member 1457241529-Aug-19 14:46 
AnswerRe: Regular Expression To Extract Everything Including the String And Before The First Space Character Pin
Richard MacCutchan29-Aug-19 20:43
mveRichard MacCutchan29-Aug-19 20:43 
GeneralRe: Regular Expression To Extract Everything Including the String And Before The First Space Character Pin
Member 1457241530-Aug-19 3:23
Member 1457241530-Aug-19 3:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.