09-15-2015, 01:52 PM | #1 |
Member
Posts: 14
Karma: 10
Join Date: Jan 2012
Device: Kindle
|
Copy one column to another problem
Hello,
I am trying to copy content of one custom column to another custom column. Problem which I am experiencing is when the source column contains multiple names split by "&" for example Fname1 Lname1 & Fname2 Lname2 When I use regex replace (.*) with \1 the result in destination column is not the names split with & but names split by coma "," for example Fname1 Lname1,Fname2 Lname2 Source column is defined as "coma separated text, like tags, shown in tag browser" + "Contain names is checked Destination column is defined as "Test, column shown in tag browser" Thank you for help. M. |
09-15-2015, 03:15 PM | #2 |
Well trained by Cats
Posts: 29,936
Karma: 55705602
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Not elegant, but maybe process in a loop (.+)(,.+) Replace in the first pass: \1 Then delete the first tag (.+,)(.+) <in the original Or capture the next set above Replace \2 (.+)(,.+) Replace in all others: &\1 MODE Append NOT TESTED |
09-16-2015, 04:20 AM | #3 |
Ex-Helpdesk Junkie
Posts: 19,421
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
|
Why are you copying to a column of a different type?
... I believe for fields with multiple values, each item is processed separately. You may be able to work around this by using Search Field: {template} ... Try unchecking "Split result". |
Tags |
column, copy |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Duplicate/Copy column | Smokva | Library Management | 6 | 09-17-2022 06:22 PM |
Copy column settings from one library to another? | badbob001 | Library Management | 3 | 07-30-2015 01:01 PM |
Copy Custom Column to another library | gabby98 | Calibre | 10 | 01-26-2014 10:59 PM |
Copy data from one column to another | Wyndham | Library Management | 3 | 11-19-2013 01:14 PM |
Column copy (one time) | wsignal | Library Management | 6 | 05-08-2013 04:41 PM |