Skip to main content

escape a single quote and replace with escaped single quote (huh?)

Solution:

[jradtke@neo bin]$ echo $TEMP | sed 's/'\''/'\\\\\''''/g'
./jradtke/Music/Metric/Fantasies/01 Help, I\'m Alive.mp3

Issue:
In an attempt to make my Lenovo tablet and Linux desktop (Fedora 16 with Amarok) experience more like my iPad and Apple desktop (OSX with iTunes) - I am trying to create a script to "sync" everything.  The feature I need most is the ability to sync only my "top rated" music files to my tablet (since I have a 32GB SD card and my music collection is around 60GB).
I figured out how to poll the MySQL database that I configured for Amarok to get the file locations, but some of the locations use a single quote in the filename.  Such as the word "I'm".  See the following:

NOTE: $TMPSYNC is a file which is the result of the query to my Amarok database

#!/bin/bash

MINRATING=7 # Minimum Song rating to sync to TABLET
SQLCMD="SELECT rpath FROM urls WHERE id IN (SELECT id FROM statistics WHERE rating > ${MINRATING});"
TMPSYNC=/tmp/.amarok.toprated.raw.${DATE}
echo ${SQLCMD} | /usr/bin/mysql -u${AMAROKUSER} -p${AMAROKDBPASS} ${AMAROKDB} > ${TMPSYNC}

Then...



[jradtke@neo bin]$ grep -v ^rpath ${TMPSYNC}
./jradtke/Music/Metric/Fantasies/01 Help, I'm Alive.mp3
[jradtke@neo bin]$ TEMP=`grep -v ^rpath ${TMPSYNC}`
[jradtke@neo bin]$ echo $TEMP
./jradtke/Music/Metric/Fantasies/01 Help, I'm Alive.mp3
[jradtke@neo bin]$ echo $TEMP | sed 's/'\''//g'
./jradtke/Music/Metric/Fantasies/01 Help, Im Alive.mp3
[jradtke@neo bin]$ echo $TEMP | sed 's/'\''/?/g'
./jradtke/Music/Metric/Fantasies/01 Help, I?m Alive.mp3

# THE FOLLOWING WILL REPLACE A TICK, WITH A... TICK
[jradtke@neo bin]$ echo $TEMP | sed 's/'\''/'\''/g'
./jradtke/Music/Metric/Fantasies/01 Help, I'm Alive.mp3

# FINALLY... WE GET TO THE FINAL DEST
[jradtke@neo bin]$ echo $TEMP | sed 's/'\''/'\\\\\''''/g'
./jradtke/Music/Metric/Fantasies/01 Help, I\'m Alive.mp3


Comments

Popular posts from this blog

RHN Satellite Server (spacewalk) repomd.xml not found

"repomd.xml not found" If you add a channel, or if your RHN cache gets corrupted, and one of your guests complains that it cannot find repomd.xml for jb-ews-2-x86_64-server-5-rpm (for example) - you need to rebuild your repodata cache. Normally this is an automated job - which is exemplified by the fact that you have obviously built out your entire Satellite environment and never had to do any of the steps you are about to do. So - some prep work: Open 3 terminals to your Satellite Server and run: # Term 1 cd /var/cache/rhn watch "ls -l | wc -l" # Term 2 pwd cd /var/log/rhn tail -f rhn_taskomatic_daemon.log # Term 3 satellite-sync --channel=jb-ews-2-x86_64-server-5-rpm Once the satellite-sync has completed, you >should< see the count increment by one.  If you are unlucky (like me) you will not. You then need to login to the Satellite WebUI as the satellite admin user. Click on the Admin tab (at the top) Task Schedules (on the left) fin

Install RHEL 7 on old HP DL380 g5

Someone at work had been running RHEL on an HP DL380 G5 and blew it up.  After several attempts at doing an installation that made me conclude the hardware was actually bad... I kept digging for the answer. Attempt install and Anaconda could not find any disks - try a Drivers Disk (dd.img) both cciss and hpsa.   -- once we did that, when the system would reboot it would say it could not find a disk. hmmm. Boot from your installation media and interrupt the startup at grub. Add hpsa.hpsa_allow_any=1 hpsa.hpsa_simple_mode=1 to the line starting with linuxefi press CTRL-X to boot. Once the system restarts after the install, you need to once again interrupt the startup and add the line from above. After the system starts, edit /etc/default/grub and add those 2 parameters to the end of the line starting with GRUB_CMDLINE_LINUX (which likely has quiet at the end of the line currently). then run # cp /boot/grub2/grub.cfg /boot/grub2/grub.cfg.orig # grub2-mkconfig -o /boot/grub2

MOTD with colors! (also applies to shell profiles)

I'm not sure why I had never looked into this before, but this evening I became obsessed with discovering how to present different colored text in the /etc/motd. A person had suggested creating a shell script (rather than using special editing modes in vi, or something) and I agree that is the simplest way of getting this accomplished quickly. This most noteworthy portion of this script is the following: RESET="\033[0m" that puts the users shell back to the original color. I typically like a green text on black background. Also - a great reference for the different colors and font-type (underscore, etc...) https://wiki.archlinux.org/index.php/Color_Bash_Prompt I found this example on the web and I wish I could recall where so that I could provide credit to that person. #!/bin/bash #define the filename to use as output motd="/etc/motd" # Collect useful information about your system # $USER is automatically defined HOSTNAME=`uname -n` KERNEL=`un