Forum Discussion

Stain555's avatar
Stain555
Copper Contributor
May 20, 2021

Attempting to identify carriage return line feed character in SQL field

I have a column on a table that appears to have some form of the carriage return/line feed character in the first byte. I have discovered this when I concatenated this with other related text columns...
access
office 365
George_Hepworth's avatar
George_Hepworth
Silver Contributor
May 20, 2021

Stain555 

You can search for hidden characters using their ASCII codes, for line feed and carriage return they are Chr(13) and Char(10) --although I never remember which is which.

 

Instr([YourTextFieldStringNameGoesHere], Chr(13)) will return a value greater than 0 if there is an instance of Chr(13) in that field, for example. 

  • isladogs's avatar
    isladogs
    MVP
    May 20, 2021

    Hi 

    For info, Chr(10) is line feed & Chr(13) is carriage return. See ASCII Codes Table 

    • debbieMassDot's avatar
      debbieMassDot
      Copper Contributor
      May 21, 2021
      OP may have to switch to text import and possibly add a column updating to only specific ASCII characters - Shift+Space (used to be called a hard space) comes to mind.

Resources