Unable to enter numeric characters in Blow Count

I am trying to input my data for blow counts. However I am unable to enter "WOH" and "50/6" in my input table to since it only accepts numeric values. Can these issues be solved with a simple text expression I am overlooking?

I have tried changing my data expression to get "0" in my sample tab for blow counts to display as "WOH" in output, but I have not gotten it to work. I looked through a few how-to-guides listed below. 

Text vs Depth: N-Value Calculation using Text Fields (how-to guide)

Text vs Depth: N-Value Calc with R for Refusal and 0 for WOH/WOR (how-to guide)

Text vs Depth: Calculates Refusal Penetration and includes WOR field (how-to guide)

Parents
  • If you right click on the table header and select "Field Properties", you will see what "type" the field is. It is probably "double", which is a number only, and is probably gray meaning you can't edit it form the project database.

    To change it to a text field, you need to go to "Data Design", and then go to file>open file>current project, and then select your table in the yellow drop down box at top, and then select the field in the left side of the dialog box, then you can change the "Type" to "Text".

    Answer Verified By: Connor Kirkland 

Reply
  • If you right click on the table header and select "Field Properties", you will see what "type" the field is. It is probably "double", which is a number only, and is probably gray meaning you can't edit it form the project database.

    To change it to a text field, you need to go to "Data Design", and then go to file>open file>current project, and then select your table in the yellow drop down box at top, and then select the field in the left side of the dialog box, then you can change the "Type" to "Text".

    Answer Verified By: Connor Kirkland 

Children
No Data