User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-578801%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%85%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E6%9C%AC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578801%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%A4%A7%E5%AE%B6%E5%A5%BD%EF%BC%8C%3CBR%20%2F%3E%E6%88%91%E5%B8%8C%E6%9C%9B%E6%A0%B9%E6%93%9A%E9%80%99%E5%85%A9%E5%80%8B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B8%AD%E7%9A%84%E6%A8%A1%E5%BC%8F%2F%E6%96%87%E5%AD%97%E5%A1%AB%E5%85%85%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E5%96%AE%E5%85%83%E6%A0%BC%E5%80%BC%E3%80%82%20%E8%AB%8B%E6%9F%A5%E7%9C%8B%E9%9A%A8%E9%99%84%E7%9A%84%E5%9C%96%E5%83%8F%E5%92%8C%E8%B3%87%E6%96%99%E3%80%82%3C%2FP%3E%3CP%3E%E4%BB%BB%E4%BD%95%E5%B9%AB%E5%8A%A9%EF%BC%8C%E8%AC%9D%E8%AC%9D%EF%BC%8C-HSS%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22HSS_0-1670488967066.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22HSS_0-1670488967066.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22HSS_0-1670488967066.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F48031i8473BFB670081E44%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22HSS_0-1670488967066.png%22%20alt%3D%22HSS_0-1670488967066.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-578801%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8B%95%E5%8C%96%E5%92%8C%E8%85%B3%E6%9C%AC%E7%B7%A8%E5%AF%AB%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-581800%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-581800%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%3CBR%20%2F%3E%E6%8A%B1%E6%AD%89%E5%9B%9E%E8%A6%86%E6%99%9A%E4%BA%86%EF%BC%8C%E6%88%91%E6%AD%A3%E5%9C%A8%E4%BC%91%E5%81%87%E3%80%82%20%E9%80%99%E4%BC%BC%E4%B9%8E%E6%98%AF%E6%9B%B4%E9%80%9A%E7%94%A8%E7%9A%84%E5%81%9A%E6%B3%95%E3%80%82%20%E6%88%91%E6%9C%83%E5%98%97%E8%A9%A6%E6%B2%BF%E8%91%97%E9%80%99%E7%A8%AE%E6%96%B9%E5%BC%8F%E5%AF%A6%E7%8F%BE%E4%B8%80%E4%BA%9B%E6%9D%B1%E8%A5%BF%EF%BC%8C%E6%88%96%E8%80%85%E6%9C%83%E4%BD%BF%E7%94%A8%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610%22%20target%3D%22_blank%22%3E%40%E5%82%91%E5%BE%B7%E5%9D%8E%E8%B2%9D%E7%88%BE%3C%2FA%3E%E7%9A%84%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%E3%80%82%3CBR%20%2F%3E%E8%AC%9D%E8%AC%9D%EF%BC%8CHSS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-581799%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-581799%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610%22%20target%3D%22_blank%22%3E%40%E5%82%91%E5%BE%B7%E5%9D%8E%E8%B2%9D%E7%88%BE%3C%2FA%3E%3CBR%20%2F%3E%E6%8A%B1%E6%AD%89%E5%9B%9E%E8%A6%86%E6%99%9A%E4%BA%86%EF%BC%8C%E6%88%91%E6%AD%A3%E5%9C%A8%E4%BC%91%E5%81%87%EF%BC%8C%E6%98%AF%E7%9A%84%EF%BC%8C%E9%80%99%E5%B0%8D%E6%88%91%E6%9C%89%E7%94%A8%E3%80%82%3CBR%20%2F%3E%E8%AC%9D%E8%AC%9D%EF%BC%8CHSS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578993%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578993%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%A6%82%E6%9E%9C%E6%88%91%E7%90%86%E8%A7%A3%E6%AD%A3%E7%A2%BA%E7%9A%84%E8%A9%B1%EF%BC%8C%E9%80%99%E6%A8%A3%E7%9A%84%E4%BA%8B%E6%83%85%E5%8F%AF%E8%83%BD%E6%9C%83%E8%B5%B7%E4%BD%9C%E7%94%A8%E3%80%82%20%E6%82%A8%E6%AF%8F%E6%AC%A1%E9%83%BD%E9%9C%80%E8%A6%81%E5%B0%87%E7%AC%AC%203%20%E8%A1%8C%E7%9A%84%E5%88%97%E8%A1%A8%E6%9B%B4%E6%94%B9%E7%82%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%88%97%E8%A1%A8%EF%BC%8C%E4%B8%A6%E4%B8%94%20Try%20%E9%83%A8%E5%88%86%E5%B0%B1%E5%9C%A8%E9%82%A3%E8%A3%A1%EF%BC%8C%E5%9B%A0%E7%82%BA%E5%BE%AA%E7%92%B0%E7%9B%AE%E5%89%8D%E4%B8%8D%E7%9F%A5%E9%81%93%E5%A6%82%E4%BD%95%E8%99%95%E7%90%86%E6%9C%80%E5%BE%8C%E4%B8%80%E5%80%8B%E5%88%86%E7%B5%84%E3%80%82%20%E5%A6%82%E6%9E%9C%E9%80%99%E6%98%AF%E6%AD%A3%E7%A2%BA%E7%9A%84%E6%96%B9%E6%B3%95%EF%BC%8C%E6%82%A8%E5%8F%AF%E4%BB%A5%E4%BD%BF%E7%94%A8%E4%B8%80%E4%BA%9B%E6%9B%B4%E5%A5%BD%E7%9A%84%E6%A2%9D%E4%BB%B6%E4%BE%86%E6%B6%88%E9%99%A4%E5%B0%8D%20Try%20%E9%83%A8%E5%88%86%E7%9A%84%E9%9C%80%E6%B1%82%E3%80%82%20%E4%BD%BF%E7%94%A8%E4%BB%A5%E4%B8%8B%E8%85%B3%E6%9C%AC%E4%BE%86%E8%99%95%E7%90%86%E7%AF%84%E4%BE%8B%E8%B3%87%E6%96%99%E8%A1%A8%EF%BC%9A%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Data%20Table(%20%22Sample_Data%22%20)%3B%0A%0AlstStates%20%3D%20%7B%22Initialization%22%2C%20%22Ramp%22%2C%20%22Heat%22%2C%20%22Other%22%7D%3B%0A%0AlstLocs%20%3D%20dt%20%26lt%3B%26lt%3B%20Get%20Rows%20Where(%20Contains(%20%3ACurrent_State_Code%2C%20%22amp%22%20)%20)%3B%0A%0ATry(%0A%20For%20Each(%20%7Bi%2C%20j%7D%2C%20lstLocs%2C%0A%20%20For%20Each%20Row(%0A%20%20%20dt%2C%0A%20%20%20If(%20(Row()%20%26gt%3B%20lstLocs%5Bj%5D%20%26amp%3B%20Row()%20%26lt%3B%20lstLocs%5Bj%20%2B%201%5D)%2C%20%0A%20%20%20%20%3ACurrent_State_Code%20%3D%20lstStates%5Bj%5D%3B%0A%20%20%20)%0A%20%20)%0A%20)%0A)%3B%0A%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578964%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578964%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%83%85%E6%A0%B9%E6%93%9A%E6%8F%90%E4%BE%9B%E7%9A%84%E7%AF%84%E4%BE%8B%E6%95%B8%E6%93%9A%EF%BC%8C%E6%88%91%E5%80%91%E4%B8%8D%E9%9C%80%E8%A6%81%E4%BA%86%E8%A7%A3%E5%85%A9%E8%80%85%EF%BC%8C%E5%8F%AA%E9%9C%80%E4%BA%86%E8%A7%A3%E8%B5%B7%E9%BB%9E%E3%80%82%20%E5%9B%A0%E7%82%BA%E6%88%91%E5%80%91%E4%B8%8D%E7%9F%A5%E9%81%93%E5%85%B7%E9%AB%94%E5%A6%82%E4%BD%95%E5%AE%9A%E7%BE%A9%3CEM%3E%E5%88%9D%E5%A7%8B%E5%8C%96%3C%2FEM%3E%E7%AD%89%E7%AD%89%EF%BC%8C%E9%80%99%E5%80%8B%E7%AF%84%E4%BE%8B%E4%B8%8D%E6%9C%83%E4%BD%BF%E7%94%A8%E9%80%99%E4%BA%9B%EF%BC%8C%E8%80%8C%E6%98%AF%E4%BD%BF%E7%94%A8%20Device_States%20%E7%9A%84%E8%A1%8C%E8%99%9F%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24DOWNLOADS%2FSample_Data.jmp%22)%3B%0A%0Astate_rows%20%3D%20Loc(dt%5B0%2C%20%22Device_State%22%5D%2C%20%22Applied_Current%22)%3B%0Astates_list%20%3D%20Transform%20Each(%7Bval%7D%2C%20As%20List(state_rows)%2C%20Char(val))%3B%0A%2F*%20we%20don't%20know%20how%20to%20define%20values%20which%20are%20to%20be%20mapped%20so%20we%20will%20just%20use%20row%20numbers%20*%2F%0Acurrent_states%20%3D%20Associative%20Array(dt%5Bstate_rows%2C%20%22Current_State_Code%22%5D%2C%20states_list)%3B%0A%0Anew_col%20%3D%20dt%20%26lt%3B%26lt%3B%20New%20Column(%22State%22%2C%20Character%2C%20Nominal)%3B%0A%0Anew_col%20%26lt%3B%26lt%3B%20Set%20Each%20Value(%0A%20As%20Constant(%0A%20%20state%20%3D%20%22%22%3B%0A%20%20ret_val%20%3D%20%22%22%3B%0A%20)%3B%0A%20If(%3ADevice_State%20%3D%3D%20%22Applied_Current%22%2C%0A%20%20ret_val%20%3D%20%3ACurrent_State_Code%3B%0A%20%20state%20%3D%20current_states%5Bret_val%5D%3B%0A%20%2C%0A%20%20ret_val%20%3D%20state%3B%0A%20)%3B%0A%20ret_val%3B%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1670517384229.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1670517384229.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1670517384229.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F48041i6CD558AFB2DE00E5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22jthi_0-1670517384229.png%22%20alt%3D%22jthi_0-1670517384229.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578962%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578962%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%3E%E5%8B%95%E6%85%8B%E6%84%8F%E5%91%B3%E8%91%97-%3CBR%20%2F%3E%3CBR%20%2F%3E%20%E2%80%9CA%20%3D%200%20amp%E2%80%9D%E5%92%8C%E2%80%9CB%20%3D%200.0001%20amp%E2%80%9D%E4%B9%8B%E9%96%93%E7%9A%84%E8%A1%8C%E6%95%B8%E3%80%82%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E4%BA%8B%E5%AF%A6%E4%B8%8A'A%20%3D%200%20amp'%20%E5%92%8C'B%20%3D%200.0001%20amp'%20%E4%B9%9F%E4%B8%8D%E6%98%AF%E5%9B%BA%E5%AE%9A%E7%9A%84%EF%BC%8C%E5%AE%83%E5%8F%AF%E4%BB%A5%E6%98%AF'AA%20%3D%200%20amp'%20%E5%92%8C'BB%20%3D%200.8%20amp'%20%E5%94%AF%E4%B8%80%E7%9A%84%E5%95%8F%E9%A1%8C%E6%98%AF%E6%88%91%E5%80%91%E9%9C%80%E8%A6%81%E5%9C%A8%E5%8C%85%E5%90%AB'%20%E7%9A%84%E5%85%A9%E5%80%8B%E5%96%AE%E5%85%83%E6%A0%BC%E4%B9%8B%E9%96%93%E5%A1%AB%E5%85%85%E5%80%BC%E6%94%BE%E5%A4%A7%E5%99%A8'%E3%80%82%20%E6%88%91%E5%80%91%E9%9C%80%E8%A6%81%E5%A1%AB%E5%85%85%E7%9A%84%E5%80%BC%E4%BE%86%E8%87%AA%E5%8F%A6%E4%B8%80%E5%80%8B%E8%A1%A8%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%E5%9C%A8%E7%B5%A6%E5%AE%9A%E7%9A%84%E8%B3%87%E6%96%99%E9%9B%86%E4%B8%AD%EF%BC%8C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%E5%9C%A8%E2%80%9CA%20%3D%200%20amp%E2%80%9D%E5%92%8C%E2%80%9CB%20%3D%200.0001%20amp%E2%80%9D%E4%B9%8B%E9%96%93%E5%A1%AB%E5%AF%AB%E2%80%9C%E5%88%9D%E5%A7%8B%E5%8C%96%E2%80%9D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E5%9C%A8%E2%80%9CB%20%3D%200.0001%20%E5%AE%89%E5%9F%B9%E2%80%9D%E5%92%8C%E2%80%9CC%20%3D%200.001%20%E5%AE%89%E5%9F%B9%E2%80%9D%E4%B9%8B%E9%96%93%E5%A1%AB%E5%AF%AB%E2%80%9C%E6%96%9C%E5%9D%A1%E2%80%9D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E7%AD%89%E7%AD%89%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E6%88%91%E5%B8%8C%E6%9C%9B%E9%80%99%E5%80%8B%E8%83%BD%E5%B9%AB%E4%B8%8A%E5%BF%99%E3%80%82%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%E8%AC%9D%E8%AC%9D%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578952%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578952%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%EF%BC%8C%3CBR%20%2F%3E%3CBR%20%2F%3E%E6%88%91%E5%9C%A8%E8%B3%87%E6%96%99%E8%A1%A8%E6%88%96%E6%98%A0%E5%83%8F%E4%B8%AD%E5%BB%BA%E7%AB%8B%E4%BA%86%E2%80%9CRequired-Current_State_Code%E2%80%9D%E5%88%97%20-%20%E7%AC%AC%E5%9B%9B%E5%88%97%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%E6%88%91%E4%BD%BF%E7%94%A8%E2%80%9CContains()%E2%80%9D%E5%91%BD%E4%BB%A4%E5%89%B5%E5%BB%BA%E4%BA%86%E7%AC%AC%E4%B8%89%E5%88%97%E3%80%82%20%E9%80%99%E5%8F%AF%E4%BB%A5%E6%8F%90%E4%BE%9B%E7%A9%BA%E5%96%AE%E5%85%83%E6%A0%BC%E7%9A%84%E9%96%8B%E5%A7%8B%E5%80%BC%E5%92%8C%E7%B5%90%E6%9D%9F%E5%80%BC%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3EIF(%20%E5%8C%85%E5%90%AB(%20%3ACurrent_State_Code%2C%20%22amp%22%20)%2C%20%3ARequired-Current_State_Code%20%3D%20%3ACurrent_State_Code%2C%20)%3CBR%20%2F%3E%3CBR%20%2F%3E%E7%84%B6%E5%BE%8C%E5%A1%AB%E5%85%A5%E7%BC%BA%E5%A4%B1%E5%80%BC%E3%80%82%20%E5%B0%B1%E5%83%8F%E5%9C%A8%E2%80%9CA%20%3D%200%20amp%E2%80%9D%E5%92%8C%E2%80%9CB%20%3D%200.0001%20amp%E2%80%9D%E4%B9%8B%E9%96%93%E5%A1%AB%E5%AF%AB%E2%80%9C%E5%88%9D%E5%A7%8B%E5%8C%96%E2%80%9D%EF%BC%8C%E4%BE%9D%E6%AD%A4%E9%A1%9E%E6%8E%A8%E3%80%82%20%E9%80%99%E4%BA%9B%E5%A1%AB%E5%85%85%E5%80%BC%EF%BC%88%E5%88%9D%E5%A7%8B%E5%8C%96%E3%80%81%E6%96%9C%E5%9D%A1%E3%80%81%E7%86%B1%E7%AD%89%EF%BC%89%E4%BE%86%E8%87%AA%E5%8F%A6%E4%B8%80%E5%80%8B%E8%A1%A8%E3%80%82%20%E4%BD%86%E6%98%AF'A%20%3D%200%20amp'%E5%92%8C'B%20%3D%200.0001%20amp'%E4%B9%8B%E9%96%93%E7%9A%84%E8%A1%8C%E6%95%B8%E4%B8%8D%E5%9B%BA%E5%AE%9A%EF%BC%8C%E6%84%9F%E6%9F%93%E6%AD%A4%E7%95%B6%E5%89%8D%E5%80%BC%E4%B9%9F%E4%B8%8D%E5%9B%BA%E5%AE%9A%EF%BC%8C%E4%BE%8B%E5%A6%82%20%E5%AE%83%E5%8F%AF%E4%BB%A5%E6%98%AF%E2%80%9CB%20%3D%200.01%20%E5%AE%89%E5%9F%B9%E2%80%9D%E3%80%82%20%E5%8F%AA%E6%98%AF%E5%85%B6%E4%B8%AD%E6%87%89%E8%A9%B2%E6%9C%89%E3%80%8Camp%E3%80%8D%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%E5%B8%8C%E6%9C%9B%E9%80%99%E6%9C%83%E6%9C%89%E6%89%80%E5%B9%AB%E5%8A%A9%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578945%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578945%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CBR%20%2F%3E%E4%BB%A5%E4%BB%80%E9%BA%BC%E6%96%B9%E5%BC%8F%E5%8B%95%E6%85%8B%EF%BC%9F%20%E4%BD%A0%E8%88%89%E4%BA%86%E4%B8%80%E5%80%8B%E4%BE%8B%E5%AD%90%EF%BC%8C%E6%89%80%E4%BB%A5%E5%BE%88%E9%9B%A3%E6%83%B3%E5%87%BA%E4%B8%80%E5%80%8B%E6%B6%B5%E8%93%8B%E9%80%99%E4%BA%9B%E8%AE%8A%E5%8C%96%E7%9A%84%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578941%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578941%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E4%BD%A0%E5%A5%BD%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F17470%22%20target%3D%22_blank%22%3E%40HSS%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%82%A8%E8%83%BD%E5%90%A6%E6%8F%90%E4%BE%9B%E4%B8%80%E5%80%8B%E7%A9%BA%E5%88%97%E6%87%89%E5%A1%AB%E5%85%A5%E4%BB%80%E9%BA%BC%E5%85%A7%E5%AE%B9%E7%9A%84%E7%AF%84%E4%BE%8B%EF%BC%9F%20%E8%81%BD%E8%B5%B7%E4%BE%86%E6%82%A8%E6%83%B3%E7%94%A8%E6%9F%90%E7%A8%AE%E6%96%87%E5%AD%97%E5%A1%AB%E5%85%85%20Device_State%20%E5%88%97%E4%B8%AD%E7%9A%84%E7%A9%BA%E7%99%BD%E5%96%AE%E5%85%83%E6%A0%BC%EF%BC%8C%E4%BD%86%E5%BE%9E%E5%9C%96%E5%83%8F%E4%B8%AD%E4%B8%8D%E6%B8%85%E6%A5%9A%E6%96%87%E5%AD%97%E6%87%89%E8%A9%B2%E6%98%AF%E4%BB%80%E9%BA%BC%E3%80%82%20%E5%8F%A6%E5%A4%96%EF%BC%8C%E8%81%BD%E8%B5%B7%E4%BE%86%E6%82%A8%E5%B8%8C%E6%9C%9B%E8%A9%B2%E6%96%87%E5%AD%97%E6%A0%B9%E6%93%9A%E6%89%80%E6%87%89%E7%94%A8%E7%9A%84%E9%9B%BB%E6%B5%81%E8%A8%AD%E5%AE%9A%E9%80%B2%E8%A1%8C%E6%9B%B4%E6%94%B9%EF%BC%8C%E7%84%A1%E8%AB%96%E6%98%AF%200%20%E5%AE%89%E5%9F%B9%E3%80%810.0001%20%E5%AE%89%E5%9F%B9%E7%AD%89%E3%80%82%E9%80%99%E6%98%AF%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%97%8E%EF%BC%9F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%91%E4%B8%8D%E6%B8%85%E6%A5%9A%E6%82%A8%E5%B8%8C%E6%9C%9B%20Current_State_Code%20%E5%88%97%E4%B8%AD%E7%9A%84%E4%BF%A1%E6%81%AF%E5%A6%82%E4%BD%95%E5%BD%B1%E9%9F%BF%E9%80%B2%E5%85%A5%20Device_State%20%E5%88%97%E7%9A%84%E6%96%87%E5%AD%97%EF%BC%88%E5%A6%82%E6%9E%9C%E7%A2%BA%E5%AF%A6%E5%A6%82%E6%AD%A4%EF%BC%89%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%AC%9D%E8%AC%9D%EF%BC%81%EF%BC%8C%3C%2FP%3E%3CP%3EDS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578899%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578899%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%97%A8%E5%82%91%E5%BE%B7%EF%BC%8C%3CBR%20%2F%3E%3CBR%20%2F%3E%E5%95%8F%E9%A1%8C%20-%20%E7%9B%AE%E5%89%8D%E7%8B%80%E6%85%8B%E4%BB%A3%E7%A2%BC%E5%88%97%E4%B8%AD%E7%9A%84%E8%A7%B8%E7%99%BC%E5%99%A8%E6%98%AF%E9%9D%9C%E6%85%8B%E7%9A%84%E9%82%84%E6%98%AF%E5%8B%95%E6%85%8B%E7%9A%84%EF%BC%9F%3CBR%20%2F%3E%E7%AD%94%E6%A1%88-%E5%8B%95%E6%85%8B%E3%80%82%3CBR%20%2F%3E%3CBR%20%2F%3E%E5%95%8F%E9%A1%8C%20-%20%E6%82%A8%E5%9C%A8%E5%B0%8B%E6%89%BE%20GUI%20%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%E9%82%84%E6%98%AF%E8%85%B3%E6%9C%AC%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%EF%BC%9F%3CBR%20%2F%3E%E7%AD%94%E6%A1%88%20-%20%E8%85%B3%E6%9C%AC%E3%80%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E8%AC%9D%E8%AC%9D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-578882%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%9B%9E%E8%A6%86%EF%BC%9A%E5%A6%82%E4%BD%95%E6%A0%B9%E6%93%9A%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B8%AD%E7%9A%84%E7%89%B9%E5%AE%9A%E5%80%BC%E5%A1%AB%E5%85%A5%2F%E6%9B%BF%E6%8F%9B%E5%85%A9%E5%80%8B%E5%84%B2%E5%AD%98%E6%A0%BC%E4%B9%8B%E9%96%93%E7%9A%84%E6%96%87%E5%AD%97%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-578882%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%B9%BE%E5%80%8B%E5%95%8F%E9%A1%8C%EF%BC%9A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%E7%9B%AE%E5%89%8D%E7%8B%80%E6%85%8B%E4%BB%A3%E7%A2%BC%E5%88%97%E4%B8%AD%E7%9A%84%E8%A7%B8%E7%99%BC%E5%99%A8%E6%98%AF%E9%9D%9C%E6%85%8B%E7%9A%84%E9%82%84%E6%98%AF%E5%8B%95%E6%85%8B%E7%9A%84%EF%BC%9F%3C%2FLI%3E%0A%3CLI%3E%E6%82%A8%E5%9C%A8%E5%B0%8B%E6%89%BE%20GUI%20%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%E9%82%84%E6%98%AF%E8%85%B3%E6%9C%AC%E8%A7%A3%E6%B1%BA%E6%96%B9%E6%A1%88%EF%BC%9F%3C%2FLI%3E%0A%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
HSS
HSS
Level IV

How to fill/replace text between two cells, based on specific values in those two cells

Created: Dec 8, 2022 03:47 AM  |  Last Modified: Jun 9, 2023 9:04 AM (7747 views)

Hi All,
I am looking to fill/replace cell  values between two cells based on pattern/text in those two cells. Please have a look into the attached image and data.

Any help, Thanks, - HSS

 

HSS_0-1670488967066.png

 

Sample_Data.jmp
0 Kudos
10 REPLIES 10
HSS
HSS
Level IV

Re: How to fill/replace text between two cells, based on specific values in those two cells

Dec 15, 2022 01:03 AM (1061 views)  |  Posted in reply to message from Jed_Campbell 12-08-2022

@Jed_Campbell 
Sorry for late replying I was on leave, yes this will work for me.
Thanks, HSS

0 Kudos

Recommended Articles