Need path only

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

othni
Posts: 34
Joined: Tue Mar 01, 2005 1:47 am
Location: San Juan, Puerto Rico
Contact:

Need path only

Postby othni » Wed Oct 03, 2007 11:47 pm

I need to capture the path for the file being processed in my output file.

So I did this:

One filter uses the @FullInputFilename macro to first add the whole thing to the beginning of the line.

The next filter is a Search/Replace that looks for @inputfilename and replaces that with NOTHING.

But this last filter is not working.

What I am trying to do is end up only with the PATH portion of it.

Is there a macro specifically for this? Why it is not working? Is there another way to do this?

Thank you

User avatar
DataMystic Support
Site Admin
Posts: 2154
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Mon Oct 08, 2007 8:42 am

It's not working because @inputFilename and other macros can't be used in the search string (for efficiency reasons).

Why not add @FullInputFilename with a \t or comma after it at the beginning of the line, then use a search/replace pattern restricted to the first tab or CSV field to remove everything after the last '\' up to the end of the field?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 2 guests