When under Data Design>LLPL> LLPL_PL
When I select "Text" from the drop-down menu, the Type for the field becomes "X" when I output to AGS.
I would like to have XN, which allows for text or number to be entered into the field.
The rule for the entry is "if the entry is blank, enter NP (non-plastic". Otherwise it is a number.
Hence Text or Number (XN).
Thank you for your support,
Thomas Ash
Also, I would like to know how to put "PA" in the "Type" field as well please--- all I am able to do now is change the "Type" to "Text", which gives me "X".
Thomas, if you mean by adding PA to the Type, that is not editable. The drop down is fixed with the entries in the Type and will not allow any new additions. Only other suggestion would be to try Memo as the type.
Thank you for your quick response,
To clarify:
PA is already an available type--- I do not wish to add it to the library, as it is already there (please see attached image)
I wish to select "PA" as the field "Type" when I export the data to AGS format.
Several entries automatically do this, such as "SAMP_TYPE". It is not clear to me what selections are made in the Data Design tab to produce this output though.
"GROUP","LLPL" "HEADING","LOCA_ID","SAMP_TOP","SAMP_REF","SAMP_TYPE","SAMP_ID","SPEC_REF","SPEC_DPTH","SPEC_DESC","SPEC_PREP","LLPL_LL","LLPL_PL","LLPL_PI","LLPL_425","LLPL_PREP","LLPL_STAB","LLPL_STYP","LLPL_REM","LLPL_METH","LLPL_LAB","LLPL_CRED","TEST_STAT","FILE_FSET" "UNIT","","m","","","","","m","","","%","%","","%","","%","","","","","","","" "TYPE","ID","2DP","X","PA","ID","X","2DP","X","X","2SF","X","2SF","2SF","X","2SF","X","X","X","X","X","X","X" "DATA","OCW02_REC_ECR_001_VC","1.00","1-2","C","03ca9beb-8b32-4c31-8897-c36acc4c5a04","001_VC_02_C","1.75","Moist, dark gray clay","Wet method","63","23","40","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_001_VC","2.00","1-3","C","7e481bad-6273-4f43-b243-7f092e47a6f2","001_VC_03_B","2.50","Moist, dark gray clay","Wet method","69","25","44","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_001_VC","2.00","1-3","C","7e481bad-6273-4f43-b243-7f092e47a6f2","001_VC_03_C","2.75","Moist, dark gray silt","Wet method","67","33","34","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_001_VC","4.00","1-5","C","41434702-e7da-4c96-a012-1e6e721c0d63","001_VC_05_B","4.50","Moist, dark gray silt","Wet method","65","35","30","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_003_VC","3.00","1-4","C","d7741883-bd07-46f0-9aeb-20189536318d","003_VC_04_B","3.50","Moist, dark gray clay","Wet method","81","30","51","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_003_VC","4.00","1-5","C","277953be-aac8-4f43-bdaf-2d95f5c900a9","003_VC_05_B","4.50","Moist, gray sand","Wet method","","","","68","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_005_VC","1.00","1-2","C","5e3b3f05-46c1-4114-9ba9-e6a38865c2fe","005_VC_02_C","1.75","Moist, gray sandy clay","Wet method","36","15","21","84","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_008_VC","1.00","1-2","C","1d0418d7-3d26-40bf-9dee-3f94171c4002","008_VC_02_B","1.50","Moist, dark gray clay with sand","Wet method","45","20","25","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_008_VC","1.00","1-2","C","1d0418d7-3d26-40bf-9dee-3f94171c4002","008_VC_02_C","1.75","Wet, dark gray clay","Wet method","59","25","34","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_008_VC","2.00","1-3","C","d7744efb-2db5-4870-a16e-b0677a2f3a3a","008_VC_03_B","2.50","Moist, gray clay","Wet method","61","28","33","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_008_VC","3.00","1-4","C","3fa2dcae-b022-47e7-a1d8-ce78203f83fe","008_VC_04_B","3.50","Moist, dark gray clay","Wet method","65","28","37","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_008_VC","3.00","1-4","C","3fa2dcae-b022-47e7-a1d8-ce78203f83fe","008_VC_04_C","3.75","Moist, dark gray clay","Wet method","63","28","35","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_009_VC","1.00","1-2","C","86358290-2f5b-4de6-a9b1-cc9374316330","009_VC_02_B","1.50","Moist, gray silt with sand","Wet method","","","","99","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_009_VC","1.00","1-2","C","86358290-2f5b-4de6-a9b1-cc9374316330","009_VC_02_C","1.75","Moist, dark gray silty sand","Wet method","","","","","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_009_VC","3.00","1-4","C","805dfb88-cf6f-4b0b-87fb-437e6c8ce98d","009_VC_04_B","3.50","Moist, dark gray clay","Wet method","39","18","21","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_009_VC","4.00","1-5","C","44d5ced5-e319-4b42-a05e-f11f24655931","009_VC_05_A","4.25","Moist, dark gray clayey sand","Wet method","34","16","18","87","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_010_VC","2.00","1-3","C","9a5c5625-9183-4c7e-9141-0261a90852d6","010_VC_03_B","2.50","Moist, gray clay","Wet method","48","22","26","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_010_VC","3.00","1-4","C","0b35de7a-1bb7-49e2-84c2-6a9ddef96653","010_VC_04_B","3.50","Moist, gray clay","Wet method","35","20","15","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_010_VC","4.00","1-5","C","104132f3-d72d-4436-9d5c-8a038c0e6583","010_VC_05_C","4.75","Moist, dark gray clay with sand","Wet method","38","20","18","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_011_VC","2.00","1-3","C","a7421ec0-439c-4e7f-a1dc-41afece542a5","011_VC_03_C","2.75","Moist, gray clay","Wet method","22","13","9.0","40","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_011_VC","4.00","1-5","C","5fd46dc3-91a8-4d38-b751-4b0d3ce4c2e1","011_VC_05_C","4.75","Moist, gray clay with sand","Wet method","39","20","19","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_011_VC","5.00","1-6","C","7e171db9-56d9-44c0-a4b0-6201c120c513","011_VC_06_A","5.25","Moist, dark gray clay","Wet method","39","20","19","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_012_VC","4.00","1-5","C","91e6eee0-ec5d-4ddc-bf46-95613ffa5860","012_VC_05_B","4.50","Moist, dark gray clay with sand","Wet method","31","19","12","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_013_VC","5.00","1-6","C","bc7682ce-c0f6-4d26-8a97-45fd6ba057f3","013_VC_06_C","5.75","Moist, dark gray sandy clay","Wet method","35","18","17","71","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_015_VC","2.00","1-3","C","a36e71ea-4796-4a6a-b118-77f8ff9648d4","015_VC_03_B","2.50","Moist, dark gray sandy clay","Wet method","28","19","9.0","74","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_015_VC","2.00","1-3","C","a36e71ea-4796-4a6a-b118-77f8ff9648d4","015_VC_03_C","2.75","Moist, dark gray clayey sand with gravel","Wet method","38","21","17","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_016_VC","4.00","1-5","C","ef494ae1-2e72-4f06-bf47-77a8be62e163","016_VC_05_C","4.75","Moist, very dark gray clay","Wet method","66","25","41","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_019_VC","1.00","1-2","C","ccbd44ce-018a-4258-b08f-721c4fb3b847","019_VC_02_B","1.50","Moist, light grayish brown sandy clay","Wet method","27","15","12","96","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_019_VC","2.00","1-3","C","ae9dc986-32da-49cc-81da-3eeb9002ee60","019_VC_03_A","2.25","Moist, gray clay","Wet method","47","20","27","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_019_VC","2.00","1-3","C","ae9dc986-32da-49cc-81da-3eeb9002ee60","019_VC_03_B","2.50","Moist, gray clay","Wet method","43","21","22","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_024_VC","1.00","1-2","C","9e342456-9ffa-4be1-aef8-a4b356f7cbc2","024_VC_02_C","1.75","Moist, dark gray clay","Wet method","71","26","45","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_024_VC","2.00","1-3","C","b47def89-1f8f-4d47-9566-7b249c6bf8d6","024_VC_03_C","2.75","Moist, dark gray clay","Wet method","73","27","46","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_024_VC","3.00","1-4","C","e3a0c37e-0983-4b01-a5b2-a4f4d7996472","024_VC_04_C","3.75","Moist, gray clayey sand with gravel","Wet method","43","18","25","43","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_028_VC","4.00","1-5","C","025ad25b-514a-435b-bf2a-64ef5349c371","028_VC_05_C","4.60","Moist, light gray sand with gravel","Wet method","","","","","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_034_VC","5.00","1-6","C","185799d0-f0ba-47de-b9f1-e9febb4e208b","034_VC_06_A","5.25","Moist, gray clayey sand","Wet method","35","16","19","59","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_037_VC","3.00","1-4","C","d9cf9cf7-9de8-422e-8331-8c5f7c282522","037_VC_04_B","3.50","Moist, gray silty sand","Wet method","","","","56","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_049_VC","5.00","1-6","C","0c78d0bc-d4bb-4a1a-94aa-1865cc9e8e10","049_VC_06_C","5.75","Moist, olive gray clay","Wet method","34","22","12","94","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_051_VC","5.00","1-6","C","aef7c23e-4993-4ad1-adee-70d2b81b5bdd","051_VC_06_A","5.25","Moist, gray clay","Wet method","41","23","18","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_058a_VC","2.00","1-3","C","6c24e1fe-49b2-44bd-82d7-ebdbf5201027","058a_VC_03_C","2.75","Moist, grayish brown sand with gravel","Wet method","","","","35","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_058a_VC","3.00","1-4","C","3c3aabfc-47d9-493b-a44a-3f9d28bddc6e","058a_VC_04_C","3.75","Moist, light gray sand","Wet method","","","","97","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_059_VC","1.00","1-2","C","bf11cb0d-57a6-45ce-9e7f-5b6c5e5e5927","059_VC_02_B","1.50","Moist, gray silty sand","Wet method","","","","83","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_064_VC","1.00","1-2","C","91429afd-a71f-45f9-9595-1ae1086c2972","064_VC_02_B","1.50","Moist, dark gray clay","Wet method","91","37","54","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_064_VC","2.00","1-3","C","d08dcf66-f382-425a-8170-3ca503b6332a","064_VC_03_C","2.75","Moist, very dark brown silt with organics","Wet method","","","","97","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_064_VC","3.00","1-4","C","d6656bb4-592f-4e9c-bdbf-e78fb298723d","064_VC_04_A","3.25","Moist, very dark gray silt with organics","Wet method","130","78","52","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_064_VC","3.00","1-4","C","d6656bb4-592f-4e9c-bdbf-e78fb298723d","064_VC_04_B","3.50","Wet, very dark brown silty sand","Wet method","92","71","21","76","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_065_VC","1.00","1-2","C","69cfce03-bcb2-4326-8a28-1e1f017a6a92","065_VC_02_C","1.75","Moist, gray silt","Wet method","70","43","27","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_065_VC","2.00","1-3","C","6abe2dcf-473c-428c-9727-b1c603e49963","065_VC_03_C","2.75","Moist, gray silt","Wet method","67","46","21","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_065_VC","3.00","1-4","C","afc404d2-a438-4cd5-b72e-ffc84b5e82e0","065_VC_04_C","3.75","Moist, dark gray silt","Wet method","73","35","38","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_069_VC","2.00","1-3","C","21e7f7e1-2fbe-4be9-9360-f2387d1b5269","069_VC_03_B","2.50","Moist, gray sandy clay","Wet method","33","16","17","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_069_VC","2.00","1-3","C","21e7f7e1-2fbe-4be9-9360-f2387d1b5269","069_VC_03_C","2.75","Moist, gray sandy clay","Wet method","24","15","9.0","92","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_069_VC","4.00","1-5","C","1ca72917-317b-4c02-944d-db8c809bb28d","069_VC_05_B","4.50","Moist, yellowish brown silty sand","Wet method","","","","61","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_070_VC","2.00","1-3","C","b2c4a64a-bd27-41dd-a33b-79880c71aefc","070_VC_03_A","2.25","Moist, gray clay with sand","Wet method","26","12","14","94","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_070_VC","3.00","1-4","C","7782a04a-848c-48b7-a1db-5f42cd906519","070_VC_04_B","3.50","Moist, dark gray silty sand","Wet method","","","","76","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_071_VC","3.00","1-4","C","ce9aa552-85ac-4f7a-bb0d-e3bde4a252b3","071_VC_04_B","3.50","Moist, dark gray clay","Wet method","34","18","16","95","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_071_VC","4.00","1-5","C","149ea851-4656-44d9-8ed0-511180b68127","071_VC_05_C","4.75","Moist, gray sandy clay","Wet method","42","19","23","78","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_072_VC","2.00","1-3","C","b544dda6-39c5-4135-87b5-ba3f759ad5d8","072_VC_03_C","2.75","Moist, grayish brown sand","Wet method","","","","21","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_073_VC","3.00","1-4","C","3642048d-077c-4ddd-92ee-1842c76a4e24","073_VC_04_C","3.75","Moist, dark gray clayey sand","Wet method","","","","39","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_074a_VC","1.00","1-2","C","a5016bbb-5674-4213-b706-b41b0a7ce43b","074a_VC_02_B","1.50","Moist, gray clayey sand","Wet method","26","16","10","93","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_074a_VC","3.00","1-4","C","77ab9fa9-1a6a-4b76-b92d-2ab43934d13a","074a_VC_04_C","3.75","Moist, gray sand","Wet method","","","","52","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_083_VC","1.00","1-2","C","e8342d94-62e5-4ae5-9ea6-c2f814488ec8","083_VC_02_C","1.75","Moist, gray clay","Wet method","43","21","22","93","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_084_VC","3.00","1-4","C","9d6f446f-8925-4206-b23a-fd7405ddd3e2","084_VC_04_B","3.50","Moist, dark grayish brown sand with silt","Wet method","","","","21","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_085_VC","0.00","1-1","C","a621ab51-6241-4993-838c-69c609e7369d","085_VC_01_A","0.25","Moist, brownish gray sand","Wet method","","","","26","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_086_VC","0.00","1-1","C","93abb826-865c-43c9-8449-fbfa7d490d7d","086_VC_01_C","0.75","Moist, gray silty clayey sand","Wet method","22","17","5.0","59","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_086_VC","1.00","1-2","C","10db7916-5966-4c08-a269-6ec7700e8122","086_VC_02_C","1.75","Moist, yellowish brown sand with gravel","Wet method","","","","11","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_098_VC","3.00","1-4","C","63119b47-a4c3-4df9-91c2-500127eeb0e3","098_VC_04_A","3.25","Moist, gray sand","Wet method","","","","87","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_110_VC","2.00","1-3","C","4f4fbd06-059a-4b01-b119-28e6a2978d84","110_VC_03_B","2.50","Moist, gray clay","Wet method","25","14","11","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_112_VC","3.00","1-4","C","41dc90fe-eb36-4f8a-aea0-fd86e16d09c6","112_VC_04_B","3.50","Moist, gray clayey sand","Wet method","31","19","12","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_117_VC","1.00","1-2","C","b2998834-0341-4f06-bb54-dcf8b176e3f0","117_VC_02_B","1.50","Wet, dark gray silt","Wet method","74","37","37","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_117_VC","1.00","1-2","C","b2998834-0341-4f06-bb54-dcf8b176e3f0","117_VC_02_C","1.75","Moist, gray clay with sand","Wet method","45","22","23","90","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_117_VC","4.00","1-5","C","f61f8e0b-e0c0-4702-a979-05a4f4e78bc3","117_VC_05_B","4.50","Moist, gray clay","Wet method","37","19","18","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_121_VC","2.00","1-3","C","f056dd59-c5e9-4c41-867e-ff0d157137da","121_VC_03_B","2.50","Moist, gray clay","Wet method","28","19","9.0","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_121_VC","3.00","1-4","C","74d10701-aacd-43ac-8a1e-322412b70fac","121_VC_04_B","3.50","Moist, gray clay","Wet method","53","21","32","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_121_VC","3.00","1-4","C","74d10701-aacd-43ac-8a1e-322412b70fac","121_VC_04_C","3.75","Moist, dark gray clay","Wet method","57","27","30","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_121_VC","4.00","1-5","C","ca67bc2e-aca8-448c-8dbf-7fd9154fea17","121_VC_05_C","4.75","Wet, dark gray sandy clay","Wet method","35","19","16","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_127_VC","1.00","1-2","C","3ea721b4-61a9-4b82-8d92-16e720bdb3dc","127_VC_02_B","1.50","Moist, gray silt","Wet method","87","51","36","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_127_VC","2.00","1-3","C","327c69b1-f219-4562-a30e-6517badcc62d","127_VC_03_B","2.50","Moist, dark gray clay with sand","Wet method","66","32","34","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_130_VC","1.00","1-2","C","f0e21338-55ed-42b5-836e-6db9bdfc95e1","130_VC_02_C","1.75","Moist, dark gray clay","Wet method","53","24","29","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_130_VC","2.00","1-3","C","e0f5535a-79ca-4b18-a2b4-e87b07a7f8ca","130_VC_03_C","2.75","Moist, dark gray clay with sand","Wet method","45","20","25","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_130_VC","3.00","1-4","C","8f540d75-8b61-4811-ab56-bbdef02b792c","130_VC_04_C","3.75","Wet, dark gray clay with sand","Wet method","49","20","29","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_136_VC","3.00","1-4","C","9052a4e2-2e6f-4af4-aaa5-260dd1a0ea5d","136_VC_04_B","3.50","Moist, gray silt with sand","Wet method","","","","","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_136_VC","3.00","1-4","C","9052a4e2-2e6f-4af4-aaa5-260dd1a0ea5d","136_VC_04_C","3.75","Moist, dark grayish brown silt","Wet method","41","26","15","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_138_VC","1.00","1-2","C","fc6dd929-70a5-4090-b744-117b9c4d9869","138_VC_02_C","1.75","Moist, dark gray sandy clay","Wet method","61","29","32","77","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_138_VC","2.00","1-3","C","181d2d55-c341-4180-bd68-1e0eab00a922","138_VC_03_C","2.75","Moist, gray clay with organics","Wet method","85","35","50","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_145_VC","1.00","1-2","C","c0b6f3be-8835-48ac-82d7-dd22a391c622","145_VC_02_C","1.75","Wet, dark gray clay with sand","Wet method","45","23","22","90","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_145_VC","2.00","1-3","C","496c8741-8cce-45d5-aeb7-e4738f6dc8dc","145_VC_03_D","3.00","Moist, gray clay","Wet method","51","23","28","98","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_145_VC","4.00","1-5","C","4db9e667-36a7-4315-9804-e9afd6d27ef9","145_VC_05_C","4.75","Moist, gray clay","Wet method","66","29","37","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_149_VC","2.00","1-3","C","252c05f0-552f-4902-a3f5-179ba61f04ac","149_VC_03_B","2.50","Moist, dark gray sandy silt","Wet method","","","","100","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_149_VC","3.00","1-4","C","b49a5d32-bf99-4173-8d7a-41d8dcba2e92","149_VC_04_B","3.50","Moist, dark gray clay","Wet method","34","23","11","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_149_VC","4.00","1-5","C","5e76a8e0-bdd0-4219-8a63-fbdb6e692ed3","149_VC_05_B","4.50","Moist, dark gray clay","Wet method","41","21","20","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_157_VC","4.00","1-5","C","a9498116-83df-41bd-934d-1237d36e584b","157_VC_05_A","4.25","Moist, gray sandy clay","Wet method","34","21","13","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_159_VC","2.00","1-3","C","5e636522-8774-499e-91ae-eaac964ee3fa","159_VC_03_C","2.75","Moist, very dark brown sandy silt","Wet method","","","","99","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_159_VC","2.00","1-3","C","5e636522-8774-499e-91ae-eaac964ee3fa","159_VC_03_D","3.00","Moist, very dark brown sand","Wet method","","","","72","Wet method","","","NP","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_162_VC","0.00","1-1","C","b2d22ff2-3a2a-4fb9-b59b-dc88ddf6ef70","162_VC_01_D","1.00","Moist, gray sandy clay","Wet method","35","19","16","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_162_VC","1.00","1-2","C","3ad18819-5a67-47b3-bb56-12a0f2ff4273","162_VC_02_B","1.50","Moist, dark gray clay","Wet method","47","24","23","","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_162_VC","1.00","1-2","C","3ad18819-5a67-47b3-bb56-12a0f2ff4273","162_VC_02_C","1.75","Moist, gray clay","Wet method","51","24","27","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_162_VC","2.00","1-3","C","0467d4de-27d2-44f9-8573-a376f369e830","162_VC_03_C","2.75","Moist, dark gray clay","Wet method","68","30","38","99","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_162_VC","3.00","1-4","C","027f057b-0f81-4c19-918a-b7bc93d5ac79","162_VC_04_A","3.25","Moist, gray clay","Wet method","61","28","33","100","Wet method","","","","ASTM D4318","GTX","","","" "DATA","OCW02_REC_ECR_163_VC","1.00","1-2","C","124bee20-e57f-4790-9c4c-bd414587e21e","163_VC_02_D","2.00","Moist, dark gray clay","Wet method","45","20","25","","Wet method","","","","ASTM D4318","GTX","","",""
I tried changing to "memo" and this did not change the type to "PA"-- it is still "X"
This is hardcoded into the AGS code in the gINT library. Unlikely this can be changed.The drop down menu for TYPE is a non editable drop down. So XN for any such additions are not possible in that drop down.
For LLPL query, check your correspondence file for export as to how it is laid out its text expression. Standard export correspondence file shows LLPL_LL like this:
LLPL_LL,"<<IIf(Not <<LLPL.Non-Plastic>>,<<LLPL.LLPL_LL>>)>>"LLPL_PL,"<<FieldType(XN)>><<IIf(<<LLPL.Non-Plastic>>,""NP"",<<LLPL.LLPL_PL>>)>>"LLPL_PI,"<<IIf(Not <<LLPL.Non-Plastic>>,<<LLPL.LLPL_PI>>)>>"