Why not simply use search/replace on a column?
Dňa 16.10.2012 1:28, "Nick" <[email protected]> napísal(-a):
> Hi All,
>
>
> Does anyone have an Excel UDF that takes data with spaces and converts to
> the double pipe format required by Dspace to store multiple values for a
> given metadata element?
>
>
>
> The example the dspace wiki gives is (
> https://wiki.duraspace.org/display/DSDOC18/Batch+Metadata+Editing):
> Horses||Dogs||Cats
>
> I need to do the same thing for bounding data that looks like:
> -56.4343 23.4545 67.4309 54.322
>
> To
>
> -56.4343 || 23.4545 || 67.4309 || 54.322
>
>
> Any help is appreciated
>
>
>
> Thanks
>
> Bob
>
>
> ------------------------------------------------------------------------------
> Don't let slow site performance ruin your business. Deploy New Relic APM
> Deploy New Relic app performance management and know exactly
> what is happening inside your Ruby, Python, PHP, Java, and .NET app
> Try New Relic at no cost today and get our sweet Data Nerd shirt too!
> http://p.sf.net/sfu/newrelic-dev2dev
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
