hi

I have a file which is delimited by right curly bracket }.

i need to fetch only few column values and bcp those values into a table, and that table contains some columns whose values doesnot exist in the input file , for those columns , a default value is given based on the column name .

How can i reformat the data in a format to bcp into the table .

Pls help .

Once you bcp out the file with delimeter. Use awk command to rearrange the data. And then bcp into the table.