Search Results

I appreciate your input and I had no idea you could use paste like this too so thanks so much for that. The results put everything with a tab after the delimiter. I want all fields concatenated but...

Not sure how. Just doing the best that I can with what I know. If you have a better way then by all means post it.

Thanks again!


Art

Thank you Alister for pointing me in the right direction. I have used paste before but never looked at the "-" function. I ended up with:

< infile paste -d";" - - - - - - - | awk '{print...

Hello,

I have a text file with the following fields:

RecordNumber
Name
Email
Date
Notes
Confirmed
MailingList

The problem is that each field is on a separate line. These seven fields...

Hello,

I need some help with PHPMaker 9 "Server Events".

trying to do a simple filter but my lack of knowledge of PHP & Mysql is getting me in a jam.

I have 2 tables:

MyMainTable = which...

Sorry for the questions. I know this is basic stuff. I use RAD software for development and doing anything extra like this is off the wall for me.

Thank you once again!


Art:)

radoulov,

Thank you!

That works fine. Is there any way to specify a sort order as the output I get is mixed together in random order or using another column to sort between all cities I...

Hello Group,

What I have is a database with about a dozen fields and one being "City".

What I would like to do is to have a custom query on a single field for multiple items (cities) but I...

Hello Group,

I need to replace the city field in “File 1 (fileld 3), with the entire record line of “File 2” (including delimiters) where the “city” field (File 1, Field 3)matches city field...

peasant thanks so much for that! It worked perfectly!

What I did was as you suggested convert the ";" delimiters in the one file first to "|" to get a common delimiter as your code uses the -F"|"...

I have 2 files

"File 1" is delimited by ";" and "File 2" is delimited by "|".


File 1 below (3 record shown):
Doc1;03/01/2012;New York;6 Main Street;Mr. Smith 1;Mr. Jones...

Awesome!

Thank you so much. I have not programmed in quite a while and I was really spinning my wheels on this one. I was never as proficient with awk as I should be. I really need to practice...

Hello,

I have 2 files delimited by "|".

File1:

1|New York
12| Buffalo
599| Syracuse


File2:

56 Kennedy |1
9 Burridge Pl|15
98 BELL ROCK |599


My goal: Is to replace the...

Scrutinizer,

Thanks so much, that is it! Exactly what I am trying to to. Now I should be able to import this in mysql or excel as CSV data.

Also many thanks to Franklin52 for what you sent!
...

Franklin52,

Thanks so much for that. What you sent is nearly perfect. The problem is that some fields like "person1" or "person2" (as well as others) could have many more than 2 or 3 lines. What...

Hello,

I have some data in a text file where fields are separated by blank lines. There are only 6 fields however some fields have several lines of data as I will explain. Also data in a...