Jump to content

Stringreplace Wildcards?

Recommended Posts

Guest sanderd

Can I use wildcards in the StringReplace function?

If yes, how?

If not, isn't there any windows CLI program wich can?

I really need it...



Link to post
Share on other sites

you can use a commandline regular expressions program to do the replacements, or you can add in a delimiter and split it, replace, and remove the delimiters.


bob goes to the store

replace go* til a space

stringsplit by spaces would give you:






use stringleft to see if it has the first two characters as go, and if so, make your replacement, then reasemble.

I imagine you could make a UDF to do it, and I might try it later. One that would use *before and after perhapse. With stringinstr, stringreplace, and stringtrim, you have a lot of tools to design the one you want.

A regular expression editor would be the way to go for really good replacements, and that is how I do it when I have a lot of data i want to adjust.

Edited by scriptkitty

AutoIt3, the MACGYVER Pocket Knife for computers.

Link to post
Share on other sites

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