Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
FIXED DELIMITED FILE
Thanks, I did define the OFS, but I don't think I have the syntax correct. I don't get a ; between the fields. Isn't that what OFS is suppose to do? BEGIN {FS="\|" ; OFS ="\;" printf("%-18s %-10s %-20s %-3s %-50s %-50s\n", "company_id","start_dt", "amt_outsd", "co_cd", "Filename", "Filedate")... -
FIXED DELIMITED FILE
yes,thank you. I think that's most of the problem. But when I run the awk script BEGIN {FS="\|" printf("%-18s %-10s %-20s %-3s %-50s %-50s\n", "company_id","start_dt", "amt_outsd", "co_cd", "Filename", "Filedate") } NR==1 {VAR1=$0} NR>=3{printf("%-18s %-10s %-20d %-3s %-50s... -
FIXED DELIMITED FILE
My data looks like this. I need it to be delimited, but when I insert a field separator ms dts does not recognize it. So the awk code below I tried to make it fixed width, but ms dts does not recogonize that either. Seems like all the fields are put into one column. Thanks. The first row of... -
FIXED DELIMITED FILE
Hi, I'm just starting to write awk scripts. In the code below I'm trying to create a fixed delimeter file so I can load it into a MS db using dts. It doesn't seem to recogonize the fixed width or field separator. Does anyone have any ideas how I can separate these fields? Thanks. BEGIN...
