remove "leading spaces" from epg xml?

[jksmurf]

Does anyone know how I can "wash" my XML-based through program that will remove the "leading spaces" from the XML?
I use batch file that I got from mvallevand (Thanks Martin, still works beautifully) to strip Chinese Characters, now just need to add something to remove the "leading spaces"

C:\Progra~1\GnuWin32\bin\sed -e "s/[\x00-\x1F\x7F-\xFF]//g" -e "s/()//g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTV.xml

ta!

k.

[mvallevand]

Try this as the search expression

"s/^[ ]*//;s/[\x00-\x1F\x7F-\xFF]//g"


Martin

[jksmurf]

Thanks Martin, quick as ever...but hmmm not quite? The ones that are correct are other replacements/clipping/concatentation using TVXB

[mvallevand]

I'm guessing you need to run sed twice, once to strip the characters to an intermediate xml file and another to strip the leading spaces.

Martin

[jksmurf]

Hmm

I tried this

Code:

C:\Progra~1\GnuWin32\bin\sed -e "s/[\x00-\x1F\x7F-\xFF]//g" -e "s/()//g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp1.xml
C:\Progra~1\GnuWin32\bin\sed -e "s/^[ ]*//;s/[\x00-\x1F\x7F-\xFF]//g" -e "s/()//g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp1.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTV.xml

but no change?

[mvallevand]

I get it now, it's not leading you want removed, it's multiple spaces (two spaces in front of the *)

"s/[\x00-\x1F\x7F-\xFF]//g;s/ */ /g"

Martin

[jksmurf]

Hmm.... sorry :confused: still no joy...

Tried a single

C:\Progra~1\GnuWin32\bin\sed -e "s/[\x00-\x1F\x7F-\xFF]//g;s/ */ /g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTV.xml

then tried a double

C:\Progra~1\GnuWin32\bin\sed -e "s/[\x00-\x1F\x7F-\xFF]//g" -e "s/()//g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp1.xml
C:\Progra~1\GnuWin32\bin\sed -e "s/[\x00-\x1F\x7F-\xFF]//g;s/ */ /g" -e "s/()//g" C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTVTemp1.xml > C:\Utils\TVXB\XML\TVXB01XML\xmltvHKBTV.xml

k.

[mvallevand]

Maybe this

"s/[\x00-\x1F\x7F-\xFF]//g;s/> */>/g"

Martin

[jksmurf]

Bingo :-) ! You da man! Thanks Martin!
I hope this helps others too.

k.

[martint123]

"s/[\x00-\x1F\x7F-\xFF]//g;s/> */>/g"

Your location say Canada - I thought it was Mars from the above. :eek:
No wonder I never got far as an admin.