nmanager Posted March 14, 2008 Report Share Posted March 14, 2008 Can a wildcard be used in Modify String Variable/Replace Substring? If so how? Looking to remove the year from a string - 12/2008 to just 12. Tried to remove /* and /? but they do not work. Can't just move over 2 characters because there is no leadng 0 on single digit months - 1/2008. Can replace / with a few blanks, then delete part of text, then trim, but looking for something a little "cleaner" Thanks Quote Link to comment Share on other sites More sharing options...
stan Posted March 14, 2008 Report Share Posted March 14, 2008 No, unfortunately there isn't any provision for the use of wild cards in the Modify String Variable command. Here's how you can do what you want with two lines. This will work if you always have a 4 digit year. Variable Set Integer %N1% from Position of Text in Variable %T1% - set the Search Text to the / character Variable Modify String: Delete Part of %T1% - start the delete from position N1 and delete 5 characters Quote Link to comment Share on other sites More sharing options...
Cory Posted March 19, 2008 Report Share Posted March 19, 2008 Or you can copy part of string from T1 beginning at one for two characters back onto T1 then replace all instances of the slash with nothing. That gets it down to two lines at least <TMVAR2:10:01:01:001:002:><TMVAR2:21:01:00:000:000:/> Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted March 19, 2008 Report Share Posted March 19, 2008 I use something like I think you want to do, seperating names and in other instances take out slash / marks out of dates. I'm sure you could alter this code to find the first slash and then delete everything from it on, leaving the month, regardless if it's one or two digits. Where I have this code find the first space you can have it find the first slash. Good Luck. <REM2:Copies Full Name><TVAR2:09:03:><MSD:75><TMVAR2:01:09:00:000:000:><REM2:Copies Full Name to T4><TMVAR2:09:12:09:000:000:><MSD:75><REM2:Finds position of the first space in T4><IVAR2:01:13:12: ><MSD:75><REM2:Copies First Name to T10 using N1 (1st position to space)><TMVAR2:10:10:12:001:N01:><MSD:75><REM2:Deletes the First Name from T4><TMVAR2:11:12:00:001:N01:><MSD:75><REM2:Finds position of the first space in T4 after First Name has been deleted.><IVAR2:01:13:12: ><MSD:75><REM2:Copies Middle Name to T11 using N1 (1st position to space)><TMVAR2:10:11:12:001:N01:><MSD:75><REM2:Deletes theMiddle Name from T4><REM2:Leaving the Last Name in T12><TMVAR2:11:12:00:001:N01:><MSD:75><TMVAR2:01:10:00:000:000:><MSD:75><TMVAR2:01:11:00:000:000:><MSD:75><TMVAR2:01:12:00:000:000:><MSD:75> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.