-----------------------------------
***** Problem Solved ****
-----------------------------------
Hello,
I have data imported from a 5 columns x 500 rows .xls file.
It all came in Single Line fields, with the following structure:
C1 C2 C3 C4 C5
entry 1 | entry 2 | entry 3 | link-for-entry-1 | separate-link-for-entry-1
[...]
entry X | entry Y | entry Z | link-for-entry-X | separate-link-for-entry-X
Can anyone think of a smarter way, other than manual processing to:
- reduce the number of columns by directly attributing to the values in the C1 column their respective HTTP link values from the C4 column; => entry-1 to become url link (name:entry-1, value:link-for-entry-1)?
- convert the C5 column from Single Line field displaying a URL to a proper URL field with a *fixed* value for Name (e.g. name:Info; value:separate-link-for-entry-1)?
I am aware that this involves field type transformations, and that it might not be possible. So far, I only tried the manual one, by creating 2 URL fields and drag/drop populating them: it works, but it'll never get done :(
Another way that I could envision, but for which I lack the necessary expertise, would be:
- two new URL fields with deluge script that would populate the name and the value of the link from the relevant columns (?)
- direct processing in Excel (?)
I'd be really greatful for any help or insight on this matter.