Jump to content

Recommended Posts

Posted (edited)

Hello forums,

How do I replace this

$sInput = "10.0.0.12>>>local\User1;IIS2\user2"

to this

$sOutput = "10.0.0.12>>>User1;user2;"

I manage to do it with functions StringInStr and StringMid, but not with StringRegExpReplace.


Thank you!

Edited by tempman
Have additional question
Posted

This?

Local $sInput = "10.0.0.12>>>local\User1;IIS2\user2"
Local $sOutput = StringRegExpReplace($sInput, "(?<=>|;)[^>]*?\\", "")
ConsoleWrite($sOutput & @LF)

 

This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.
Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe here
RegExp tutorial: enough to get started
PCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta.

SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.
SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.
An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.
SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)
A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!
SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)

Posted

I do not want to spam the forum, but I have an additional question

How do I replace this 

$sInput = "10.0.0.12>>>Jordan;Jason Smith;Ron;"

to this 

$sOutput = "10.0.0.12>>>Jordan;Ron;"

So, any string with space (Jason Smith;) is no need


Thank you!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...