# Any quick way to strip xml code and make it comma delimit?
**URL:** https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508
**Category:** PittSpeed Off Topic
**Created:** [July 12, 2006, 12:40pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508 "2006-07-12T12:40:59Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 12:40pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/1 "2006-07-12T12:40:59Z")
Pulling email addys and domains out of an xml txt file and seperating by commas is the most horribly boring tedious task evar!!!:rant:
---
### Author:  [@Jeff95TA](https://forums.speedlife.net/u/Jeff95TA)
#### Post date: [July 12, 2006, 12:49pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/2 "2006-07-12T12:49:01Z")
Not sure I understand completely, but Excel lets you work with comma delimiting.
---
### Author:  [@fshowcars](https://forums.speedlife.net/u/fshowcars)
#### Post date: [July 12, 2006, 12:57pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/3 "2006-07-12T12:57:35Z")
dude… wtf/
excel 101~!!! hahaha
---
### Author:  [@whitey](https://forums.speedlife.net/u/whitey)
#### Post date: [July 12, 2006, 1:00pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/4 "2006-07-12T13:00:13Z")
nope… do it by hand… there is no other way to do it!
PS, perl could do this with like 20 lines of code
---
### Author:  [@fshowcars](https://forums.speedlife.net/u/fshowcars)
#### Post date: [July 12, 2006, 1:02pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/5 "2006-07-12T13:02:57Z")
i have a perl code to do extractions… just use the scriptomatic!
i don’t understand why excel couldn’t do this? i’ve pulled XML into it before and chopped it up.
---
### Author:  [@whitey](https://forums.speedlife.net/u/whitey)
#### Post date: [July 12, 2006, 1:05pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/6 "2006-07-12T13:05:46Z")
> [@fshowcars](#):
>
> i have a perl code to do extractions… just use the scriptomatic!
>
> i don’t understand why excel couldn’t do this? i’ve pulled XML into it before and chopped it up.
user error :booty:
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 1:05pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/7 "2006-07-12T13:05:47Z")
> [@fshowcars](#):
>
> dude… wtf/
>
> excel 101~!!! hahaha
ITS NOT COMMA DELIMITED YET\>\>IT NEEDS TO BE, don;t make me pl0wned j00 0 nub!! This is what I get regardless of file type or editor. Even in Office 2003 xml editor I cant save as text delimitted.
\
\
\
\
\
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 1:06pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/8 "2006-07-12T13:06:27Z")
> [@whitey](#):
>
> nope… do it by hand… there is no other way to do it!
>
> PS, perl could do this with like 20 lines of code
I dont know Pearl that well. Chopping it up in notepad now.
---
### Author:  [@ninjenn](https://forums.speedlife.net/u/ninjenn)
#### Post date: [July 12, 2006, 1:07pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/9 "2006-07-12T13:07:13Z")
You can do it with PHP… it’s not hard, just tedious to make it work properly!
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 1:10pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/10 "2006-07-12T13:10:20Z")
> [@ninjenn](#):
>
> You can do it with PHP… it’s not hard, just tedious to make it work properly!
better than 992 lines of code cutting?
---
### Author:  [@fshowcars](https://forums.speedlife.net/u/fshowcars)
#### Post date: [July 12, 2006, 1:12pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/11 "2006-07-12T13:12:40Z")
> [@Be\_Rad](#):
>
> ITS NOT COMMA DELIMITED YET\>\>IT NEEDS TO BE, don;t make me pl0wned j00 0 nub!! This is what I get regardless of file type or editor. Even in Office 2003 xml editor I cant save as text delimitted.
> \
> \
> \
> \
> \
what is this fagtority for??? some bullshit web shit for SCF :greddy: if so, fuck it.
if it’s something legit, maybe you can just properly export the xml into a delimited format :kekegay:
if it’s super top-secret then i understand.
if it’s GFI then you’re just doing it wrong.
🙂
---
### Author:  [@77rednecktruck](https://forums.speedlife.net/u/77rednecktruck)
#### Post date: [July 12, 2006, 1:16pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/12 "2006-07-12T13:16:00Z")
you guys all suck, hire some young girl intern who wears short skirts and low cut tops to do your tedious work while you fuck off and read Pittspeed all day. :doh:
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 1:26pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/13 "2006-07-12T13:26:18Z")
> [@fshowcars](#):
>
> what is this fagtority for??? some bullshit web shit for SCF :greddy: if so, fuck it.
>
> if it’s something legit, maybe you can just properly export the xml into a delimited format :kekegay:
>
> if it’s super top-secret then i understand.
>
> if it’s GFI then you’re just doing it wrong.
>
> 🙂
ROFL. Alright expert, you can’t export anything other than .xml through GFI now can you? :greddy2:
---
### Author:  [@ninjenn](https://forums.speedlife.net/u/ninjenn)
#### Post date: [July 12, 2006, 1:28pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/14 "2006-07-12T13:28:26Z")
> [@Be\_Rad](#):
>
> better than 992 lines of code cutting?
Hell yes!!! All you need is one looping command written properly!! As long as every line has the same values to remove/split, it would work OK.
I don’t know if I will have time tonight (I’m working 16 hours a day every M-F) but if you email me the file I can look at it.
Or, by tonight you could probably be done with it by hand… :kekegay:
---
### Author:  [@fshowcars](https://forums.speedlife.net/u/fshowcars)
#### Post date: [July 12, 2006, 1:30pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/15 "2006-07-12T13:30:14Z")
> [@Be\_Rad](#):
>
> ROFL. Alright expert, you can’t export anything other than .xml through GFI now can you? :greddy2:
don’t export it… look for the native listing in the gfi directory… that’s how i chopped it up real quick when the whitelisting corrupted back when. gfi support had some tool to use as well! gotta stop the services to copy the file though… pretty sure there’s an open file lock if it’s running
:whitey:
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 1:48pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/16 "2006-07-12T13:48:22Z")
> [@fshowcars](#):
>
> don’t export it… look for the native listing in the gfi directory… that’s how i chopped it up real quick when the whitelisting corrupted back when. gfi support had some tool to use as well! gotta stop the services to copy the file though… pretty sure there’s an open file lock if it’s running
>
> :whitey:
Access FTW~! Didnt have to stop services. GFI\
### Author:  [@whitey](https://forums.speedlife.net/u/whitey)
#### Post date: [July 12, 2006, 1:55pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/17 "2006-07-12T13:55:47Z")
booooring… should have just did some chomping instead
---
### Author:  [@berad](https://forums.speedlife.net/u/berad)
#### Post date: [July 12, 2006, 2:04pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/18 "2006-07-12T14:04:11Z")
> [@whitey](#):
>
> booooring… should have just did some chomping instead
csv is supposed to be comma delimitted but I open it in notepad and no commas, ugghh. Time to go home!
---
### Author:  [@Atreyu](https://forums.speedlife.net/u/Atreyu)
#### Post date: [July 13, 2006, 5:41am UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/19 "2006-07-13T05:41:55Z")
I could hack the mainframe but if the database is encoded the whole system might go down. :dunno:
---
### Author:  [@fshowcars](https://forums.speedlife.net/u/fshowcars)
#### Post date: [July 13, 2006, 4:10pm UTC](https://forums.speedlife.net/t/any-quick-way-to-strip-xml-code-and-make-it-comma-delimit/183508/20 "2006-07-13T16:10:50Z")
you should of asked word processing :kekegay: