removing period from file names

[Laura Brody]

I would rename that mess so that ".pdf" stays, but spaces and "." are
changed to "_". This can be done with sed in Linux or use filePro with
mid() and xlate().

Maybe you could post your script so that we can offer suggestions so that
it would work properly.

Laura Brody

On Wed, Oct 2, 2019 at 4:17 PM scooter6--- via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> I have a bunch of XML data I import to a filePro database (5.6.10R4) on
> CentOS 7
>
> Several of the fields are names of files that have been uploaded to the
> same server
>
> We get silly client that like to name their files something like:
> T01245.John.Smith_Statement.Oct2019.pdf
>
> Through my code I come up with my own naming convention and I do a system
> call to a script that renames the file - but it doesn't seem to work on
> file names that have several '.' in them
>
> I pass dd=chr("34"){name of the existing file name{chr("34") but that
> doesn't seem to work
> dc=chr("34"){name I am changing file to{chr("34")
>
> system "/path/to/my/script.sh"<dc<dd  (which is a script that simply does a
> mv in the directory the files are located)
>
> Wouldn't filepro be passing quotes "  in this instance so Linux wouldn't
> then care if the name of the file had multiple '.' in it?   It works as
> designed for any file names that don't have multiple '.' in them...
>
> thanks
>
> Scott
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20191002/783a4f32/attachment.html
> >
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20191002/d2ff50e1/attachment.html>