Click here to Skip to main content
15,902,903 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: What is the regular expression for this string? Pin
Richard MacCutchan23-Mar-23 3:55
mveRichard MacCutchan23-Mar-23 3:55 
AnswerRe: What is the regular expression for this string? Pin
jschell23-Mar-23 6:24
jschell23-Mar-23 6:24 
AnswerRe: Where to start - need to extract...using regular expression Pin
k505415-Mar-23 10:39
mvek505415-Mar-23 10:39 
QuestionRegular expression to return all keys in a Bibtex file Pin
Member 159423565-Mar-23 5:46
Member 159423565-Mar-23 5:46 
AnswerRe: Regular expression to return all keys in a Bibtex file Pin
Richard Deeming5-Mar-23 21:36
mveRichard Deeming5-Mar-23 21:36 
GeneralRe: Regular expression to return all keys in a Bibtex file Pin
Member 159423566-Mar-23 19:48
Member 159423566-Mar-23 19:48 
AnswerRe: Regular expression to return all keys in a Bibtex file Pin
jschell8-Mar-23 6:57
jschell8-Mar-23 6:57 
QuestionRemove all double quotes not directly preceded or directly followed by a semicolon. Pin
Guus20053-Mar-23 3:55
Guus20053-Mar-23 3:55 
Hi,

I have 3000 large csv files which give an error when i bulk insert them into a sql server table. This is caused by the fact that some text fields, which are surrounded by double quotes sometimes have quotes in them:

1;200;345;"Apotheker "Blue tongue"";"Apeldoorn";12;"ABCD12"
2;232;312;"Café "Blue Oyster";"Rotterdam";33;"DCBA21"

Sometimes 1 and sometimes 2 double quotes too many.
They need to be removed or replaced by single quotes.

Like this:
1;200;345;"Apotheker Blue tongue";"Apeldoorn";12;"ABCD12"
2;232;312;"Café Blue Oyster";"Rotterdam";33;"DCBA21"

In short the solution is this:
Remove all double quotes not directly preceded or directly followed by a semicolon.

I bought RegexBuddy and RegexMagic to help me on my quest but no solution is forthcomming.

I want to use powershell to scan all the files and replace where necessary.

I hope you can help me.

Thanks for your time
AnswerRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Richard Deeming3-Mar-23 4:05
mveRichard Deeming3-Mar-23 4:05 
GeneralRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Guus20053-Mar-23 5:19
Guus20053-Mar-23 5:19 
GeneralRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Richard Deeming5-Mar-23 21:27
mveRichard Deeming5-Mar-23 21:27 
AnswerRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
jschell6-Mar-23 6:45
jschell6-Mar-23 6:45 
Questionregex expression for us addresses Pin
jpcodex15321-Feb-23 14:55
jpcodex15321-Feb-23 14:55 
GeneralRe: regex expression for us addresses Pin
PIEBALDconsult21-Feb-23 15:02
mvePIEBALDconsult21-Feb-23 15:02 
GeneralRe: regex expression for us addresses Pin
jpcodex15321-Feb-23 15:25
jpcodex15321-Feb-23 15:25 
GeneralRe: regex expression for us addresses Pin
PIEBALDconsult21-Feb-23 15:30
mvePIEBALDconsult21-Feb-23 15:30 
GeneralRe: regex expression for us addresses Pin
Kenneth Haugland21-Feb-23 18:36
mvaKenneth Haugland21-Feb-23 18:36 
AnswerRe: regex expression for us addresses Pin
jschell22-Feb-23 6:06
jschell22-Feb-23 6:06 
GeneralRe: regex expression for us addresses Pin
trønderen22-Feb-23 12:04
trønderen22-Feb-23 12:04 
GeneralRe: regex expression for us addresses Pin
jschell23-Feb-23 6:09
jschell23-Feb-23 6:09 
GeneralWell no that isn't how it works Pin
jschell13-Feb-23 4:42
jschell13-Feb-23 4:42 
QuestionProblem combining REGEX expressions Pin
Member 156868422-Jan-23 18:40
Member 156868422-Jan-23 18:40 
AnswerRe: Problem combining REGEX expressions Pin
Member 156868423-Jan-23 3:25
Member 156868423-Jan-23 3:25 
GeneralRe: Problem combining REGEX expressions Pin
jschell24-Jan-23 10:38
jschell24-Jan-23 10:38 
Questioni need a regular expression to match a single word starting with m(...followed by any text but not space and )containing Manager Pin
anandssunku8-Jan-23 23:10
anandssunku8-Jan-23 23:10 

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.