Regex to Remove Path

by Richie88 at 2013-02-13 20:31:50

Hey Guys,

Just trying to get a regex code to remove a path, I’m building csv files but when a new file is created for some reason it is appending the path/file name to the front of it and causing problems.

Can’t for the life of me work out as to why, so what I’d like to do is simlpy remove the path via a regex code?

The path is always the same (For now)

C:\DropBox\Data Loader\CA no PL\FV.csv @{Cust Id=2212; Store=; First Name=dddd; Last Name=dsss; Follow Up=11/19/2012; Address=Street;
Suburb=ALDERLEY; State=QLD; Post


May occur a few times (If theres 2 new files created)

Once the file is created there is no problem, I could create them all then re-run the script, but i need it so other people can run it in future!

Cheers
by Richie88 at 2013-02-13 23:08:58
Ended up getting it cheers :slight_smile:

Always the way after you post something… :smiley:
by mjolinor at 2013-02-14 03:53:43
Any help?

$test = 'C:\DropBox\Data Loader\CA no PL\FV.csv @{Cust Id=2212; Store=
; First Name=dddd; Last Name=dsss; Follow Up=11/19/2012; Address=Street; Suburb=ALDERLEY; State=QLD; Post'

$test -replace '^.+(@{.+)$','$1'

@{Cust Id=2212; Store=; First Name=dddd; Last Name=dsss; Follow Up=11/19/2012; Address=Street; Suburb=ALDERLEY; State=QLD; Post
by MattG at 2013-02-14 18:08:21
Eww. Ugly string. I won’t ask why you need to work with a string in that form. ;D Anyway, I would avoid regexes altogether in a simple case like this. I did the following:
$test = 'C:\DropBox\Data Loader\CA no PL\FV.csv @{Cust Id=2212; Store=
; First Name=dddd; Last Name=dsss; Follow Up=11/19/2012; Address=Street; Suburb=ALDERLEY; State=QLD; Post'
"@$($test.Split('@')[1])"