I’m using a shell script to pull some data from a mySQL database but some of the data is coming back with a return within the field, which is messing up my reading of it as I am delimiting it by ASCII 13, then by ASCII 9 to get each field. Is there another means to read data returned from mySQL other than a delimiter, like in PHP where the data comes back as separate rows in an array?
Here’s an example of the data I get back if that will help:
id itemName itemStatus whoIs itemDesc itemFolder itemPath skuNum imageFolderPath needsSwatch hotItem photoStatus
–>good data
6671 Answering the Call - Nurses of Post 122 - 06575 Production Ed nurse book 06575_AnsweringTheCall_NW IMAGEDUMP:Online_Shop_Originals:2008:NW:NW_books:06575_AnsweringTheCall_NW NULL NULL No No 0
–>bad data
6691 Dickies Solid Blocked V-Neck Top - 06720<–there’s a line break here
Production Ed CP Product 06720_DickieSolidBlockVneck_CP IMAGEDUMP:Online_Shop_Originals:2008:CP:CP_custom_scrubs:06720_DickieSolidBlockVneck_CP NULL NULL No No 0
I worked around it by cleaning the db up first:
“UPDATE itemStatus SET itemName = replace(replace( itemName ,char(13),‘’),char(10),‘’) WHERE itemName LIKE concat(‘%’,char(13)) or itemName LIKE concat(‘%’,char(10))”