DataMystic

pipe text file

Hi all
The following maybe very easy to do but I cant seem to get it done.

Every time ### shows up in column A replace it with the content of column B

Any ideas?

Lets split the files without the names first… And then once we have the split files we can rename the file names according to the content of one of the columns in the split files (in my case, I will include another column in the files with the Mas and Bid and so on info for the above file name repla...

I may not know what I am talking about here…but… How about going at it in 2 steps. 1. Marking the split points by adding a divider line Something like: Mashad Mashad Mashad =====Mas===== Bidjar Bidjar Bidjar =====Bid===== 2. Splitting the files to: Mas.txt Bid.txt Maybe the above can be done without...

I was successful in getting it done using the other way the problem is it takes 10 days of computer work to do extraction. My hope is that this way by using split instead I could cut down the time to few hours instead. It would be great to have this function of split by column built in to the progra...

Hi gurus! I have a very large pipe file which is sorted according to the first column. I need to split this large file in to many files according to only first 3 bytes of the first column. For example: All references starting with AAA Should split to text file AAA.TXT All references starting with AA...

sent to your email....
thanks for your help.

I have to be honest..i am way over my head here with this…. Lets simplify! I was trying to do the same thing which is to generate a new filter but the filter kept coming out corrupt. I can still do this. what I need from you is a template which I can use to generate this filter and the locations whi...

when i run the filter i get the following error:
line: 25
char: 44
error: unfermented string constant
code: 800A03F7
Source: microsoft jscript compilation error

That is correct, we did talk about this in the email but at the time i was looking at 100 deferent categories. If I had only 20 of them or 50 or even 100 I could do what you said…the problem is I have 3000+ deferent types/names at the moment and the number change from update to update (I plan on hav...

Dear Simon I am having a very difficult time accomplishing the following. I have a very long list of keywords on a text file which I want to use to create separate files with. The list: Persian-rugs Indian-rugs Mashad Tabriz Isfahan Bidjar Gabbeh Shiraz And so on……. The filter needs to look at rugs....