Timeline for Replacing two characters of field in attribute table using QGIS Field Calculator?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 17, 2017 at 14:59 | history | edited | Peter Francon |
edited tags
|
|
| Sep 17, 2017 at 14:51 | answer | added | Peter Francon | timeline score: 1 | |
| Sep 6, 2017 at 13:09 | history | tweeted | twitter.com/StackGIS/status/905417748246921216 | ||
| Aug 22, 2017 at 23:23 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
edited title
|
| Aug 21, 2017 at 9:53 | comment | added | Kazuhito | Thanks @Joseph , I wish I could... Honestly I had been noise at best. Will wait for Peter to post his solution when he has time. | |
| Aug 21, 2017 at 9:40 | comment | added | Joseph | @Kazuhito - I think you should consider posting your comment as an answer as you helped the original poster come to a working solution ;) | |
| Aug 19, 2017 at 16:21 | comment | added | Ed Rollason | If this is solved could you add it as an answer and accept the answer so people can readily see the solution? | |
| Aug 19, 2017 at 12:57 | comment | added | Kazuhito | aah! my double apologies. Glad you solved it! | |
| Aug 19, 2017 at 12:40 | comment | added | Peter Francon | Solved in an hour! Thank you Kazuhito. I used your revised code, getting the the same error. However, removing a single '=' produced the correct result. CASE WHEN "BC_NR_TYPE" = '7777' THEN replace("BC_NR_LU_F" , right("BC_NR_LU_F", 2), '99') End Brilliant, you have saved me hours. Many thanks! | |
| Aug 19, 2017 at 12:28 | comment | added | Kazuhito |
My apologies... the latter part should have been replace( "COLUMN_2" , right("COLUMN_2",2), '99').
|
|
| Aug 19, 2017 at 12:09 | comment | added | Peter Francon | Thank you Kazuhito, I entered the expression using the correct field names... CASE WHEN "BC_NR_TYPE" == '7777' THEN replace(right("BC_NR_LU_F", 2), '99') End and had the errors... Parser Error: syntax error, unexpected EQ Eval Error: No root node! Parsing failed? The Attribute Table is in Edit mode. In the Field Calculator I selected 'Update existing Field': BC_NR_LU_F (or COLUMN_2). | |
| Aug 19, 2017 at 11:44 | comment | added | Kazuhito |
Please try CASE WHEN "COLUMN_1" == '7777' THEN replace(right("COLUMN_2", 2), '99')
|
|
| Aug 19, 2017 at 11:29 | review | First posts | |||
| Aug 19, 2017 at 11:33 | |||||
| Aug 19, 2017 at 11:24 | history | asked | Peter Francon | CC BY-SA 3.0 |